MS Excel 2003 cannot auto calculate formula, need to press F9 each time
I don't know why my excel 2003 new worksheet cannot auto calulate
formula (eg. summation), i need to press F9 and it will refresh and
show the new figure. there is "calculate" word at the left hand bottom
of the screen.
what is the likely reason ? it was running fine 2 weeks ago.
any advise is greatly appreciated.
Tools>Options>Calculation tab, check Automatic
Microsoft MVP - Excel
<firstname.lastname@example.org> wrote in message news:email@example.com...
| I don't know w...Error message needed if incorrect Date Of Birth (DOB) entered
In cell D6 I have a DOB entered....in cell E6 I have a datedif function that
has 3 conditional formatting set as:
1 - If D6 is blank, E6 is blank.
2 - If DOB in D6 is between 18 - 24 then E6 shows age and cell is yellow.
3 - If DOB in D6 is 25 or over then E6 shows age and cell is blue.
What I need is when a DOB is entered in D6 under 16 years old, then D6
returns an error message -" You have Entered an Age under 16 Years - Retry!!
I have tried Data Validation, but cant get a message from tha as I dont know
what to set as the date validation.
I do need a...Formula Help (to many expresions)
Could one of you give me a hand with this...
I'm trying to put a formula in a spreadsheet that has too many
expressions in it. I understand there is a limit to the number of
equations that can be in a formula but there must be a way around the
Or maybe another way to write the formula?
What I am trying to say in the formula is that if...
If X is less than 09 then B1 = what's in cell C2
If X is less than 25 then B1 = what's in cell C3
If X is less than 51 then B1 = what's in cell C4
The expression I have written looks like this...
Using Excel XP, I would like to count the number of occurences that fall
between two numbers. For example, I would like to count how many occurences
that are between 5 and 10 in A1:A7. I tried =COUNTIF(A1:A7,">=5,<=10 ")
but it does not return the correct value. Any help would be appreciated.
Vaya con Dios,
"Mike" <windme@co...simple countif formula
Column B in my spreadsheet consists of 10 rows with one letter in each cell.
I would like a formula to count cells B1,B3,B5,B7 and B9 only if the value
in each of those cells is "H". I have tried a simple formula like this
=countif(B1,B3,B5,B7,B9,"H") but it does not work.
Thanks for your help with this formula.
"Brian" <Brian@discussions.microsoft.com> wrote in message
> Column B in ...mscvr71.dll help
How do I make my VS.net 2003 software not depend on
Use static linking. I don't know where to set the option in VS7, but it used to be under
Code Generation where you selected the desired C runtime library to use. In VS6 we had a
choice between a dynamically-linked runtime and a statically-linked runtime. I've not had
to make this choice under VS7 so I'm not sure where, in their overly-clever and completely
gratuitous reimplementation of the user interface, this has been hidden.
On Sat, 21 Feb 2004 22:24:56 GMT, firstname.lastname@example.org wrote:
&g...Help with ShowFilter Macro
I'm trying to use this ShowFilter UDF written by Tom Ogilvy (see bottom of
post). It says to use...
....in a cell to show the criteria for Column B. For one thing, I don't
understand the cells B2 and B3 business. What is supposed to be in those
I would like this function to appear in the cell directly above or below the
Autofilter menu cell. How do I change the function if the Autofilter criteria
menu is in, cell A3, for example, and I want the criteria (this function) to
appear just above, in cell A2?
After trying all so...How to view the code for excel built-in functions?
Is it possible? -For example the function PMT().
No, the code is compiled, so it would likely be less than useful anyway.
About the best you can do is check out the equations used in Help (see
In article <OSU3OXOBGHA.1676@TK2MSFTNGP09.phx.gbl>, "serdar" <email@example.com>
> Is it possible? -For example the function PMT().
...Publisher 2003 Viewer is needed
Can Microsoft create a free viewer program for .pub files like they have for
the other programs in Office?
Can they? Yes
Will they? Unlikely
Larry M. in Illinois wrote:
> Can Microsoft create a free viewer program for .pub files like they have for
> the other programs in Office?
Larry M. in Illinois <Larry M. in Illinois@discussions.microsoft.com>
was very recently heard to utter:
> Can Microsoft create a free viewer program for .pub files like they
> have for the other programs in Office?
Could they? Yes
Is it profitable for them to do so? Probably not.
W...Help with automating file name
I have the following code that exports the below query to excell. I would
like the files name to include the month and date. How would I format this?
DoCmd.OutputTo acOutputQuery, "qryShopOrderSqFtShippedSummaryExport",_
mattc (at) saunatec [dot] com
Message posted via AccessMonster.com
> I would
> like the files name to include the month and date.
Uh, . . . the date _always_ includes the month, unless you're r...Please help with last formula for order form.
I am able to accomplish this with 1 column by the formulas below.
Cell H160 is the subtotal: =IF(SUM(H72:H111)>0,SUM(H72:H111),"")
Cell H166 the total: =IF(SUM(H160)>0,SUM((H160*H163)+H160),"")
Cell H163 is for Tax.
I am almost finished creating an order form. I would like to get the SUM
of 3 different columns that are separated. I am not able auto fill
strait down the column, because the information is separated in groups
with titles, and the cells are not identically sized.
I tried varations of this formula:
=IF(SUM(H72:H111)+(116:131)+(135:154)>0,SUM ((H72:H...countif problem.
I wrote a formula in a cell that contains the following:
=countif(f5:f268,"> char(32)") / countif(e5:e268,"> char(32)")
I have verified that any unused cells have blanks spaces in them.
Both columns have data in the same rows so the counted value for each
column should be the same but it isnt. All cells contain only numbers or
letters and the cells format is general.
Not sure I get it, but try
=countif(f5:f268,">"&char(32)) / countif(e5:e268,">"&char(32))
"psion" <firstname.lastname@example.org> w...Need Hyperlink from Menu Page to work in email
I have a workbook with several tabs. First tab is a "menu" type page
(summary of other pages). Currently I have hyperlinks to all the other pages
from the menu page. What I want to be able to do is copy the menu page into
an email and enable the users to click on the existing hyperlinks (whatever
adjustments needed) to go directly to their page of the workbook. Using
Excel 2007. Please advise how to do this and what changes may be need for
both options to work.
...SmartList Restrictions help
I built a SmartList that is based on the Year-to-Date Transaction Open file,
and has the Account Master linked to it. I want to restrict it to accounts
that begin with 36, 38, or 2504. I tried adding a restriction that says
"Account Number:Account_Segment_Pool1 begins with 36 OR 38 OR 2504", but I
got no results when I did it that way. I also set up 3 separate
restrictions, but that didn't work either.
Is this possible? I can't find much information about how to write
restrictions in SL Builder.
...Conditional formatting help #4
My problem is that, that i want to ignore blank i mean i had set a
conditional formatting say
A B C D
24.9 25.9 25 25.8
22.6 23.4 22.5 23.3
If value in ColA is less than value in ColC, cell A1 is shaded blue OR
value in ColB is greater than value in ColD, cell B1 shaded blue.
I have done above formatting but my problem is that if i dont enter
anything in colC then also colA is shaded in blue similarly if i dont
enter any value in colD then also col B is shaded.I mean i want to
ignore the blank.I need , if col C is blank then the Col A must be
normal .& if col D is blank & i ent...help plz
my account has been inactive how to i reacctivate it?
What account and what does this have to do with Outlook?
"heather" <email@example.com> wrote in message
> my account has been inactive how to i reacctivate it?
...Help with queries
This is the first time after school that I am trying to use ms access at
work and i need ur help in creating a query.
Any help will be highly appreciated!!
Here is what I need...
I have relatively small ms acces database with about 1000
I have 3 colums
date ipaddress sitename
12/09 188.8.131.52 A
12/09 184.108.40.206 A
12/09 220.127.116.11 A
12/09 18.104.22.168 B
12/09 22.214.171.124 C
What i need is if an ipadress is recorded more t...Plugins, more info needed
We are looking at adding plugins to our app, but i am not sure what the best
way of doing would it be.
Does anybody know where i could find some example of project with their
plug-ins. Preferably some code to play around with would be great.
How would my app load those plugins? would they all be Dll's that load at
We want to offer an SDK eventually allowing users to create their own
plugins, so we want to do it properly to ensure that it is as flexible as
Typically, you have developers create a dll your app will
load that exports cert...Need help to choose loyalty program integrated with website
My name is Alex and I am working for franchise company using RMS
We are looking for loyalty program integrated with web store.
We have 12 franchisee stores using RMS and they are all conneted to
our HQ system in main office.
We want customers to earn point for each sales and redeem their points
only at our website. (not on off-line store)
Can anybody recommend best solution for our plan?
...Help And Advive For A Novice
HELP AND ADVICE FOR A NOVICE
This Is Not A Question About Using Excell But How To Download E -books
I Have Purchased 2 E-books (a)f1 Excell And (b) Financial Statements.
Encountered Difficulty In Downloading Because The Instructions Were Not
Very Clear For Novice And Message Flagged Up "zip File Corrupted"
I Have Utilised My Permitted Downloads. Therfore I Have Not In A
Position To Use The E-books
Joe Williams's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23...formula help #42
What formula would I use to search down a column find a name and report the
number in the next column, this would be multiple times, the numbers to be
The added number reported then to be multiplied by another number and then
to be subtracted from another fixed number in a specific cell.
Thanks in advance
You can sum the corresponding cells matched without having a dedicated
column of numbers.
"Boenerge" <Boenerge@discussions...HELP! Balloon Payments in Debt Reduction
I have had this problem for so long it is getting really
frustrating. When I put a debt into the debt reduction
plan, it always puts a balloon payment on my first
payment. Then, if I don't make that payment, it just
builds and builds and builds with each subsequent payment
I do make.
How do I get rid of this? I removed the debt from my
reduction plan the first time and that cleared it. But,
the moment I started paying on the debt, it returned.
Now, it's to the point that I can't get rid of it at
all. When I remove the debt from the plan, it will do
the same thing w...SUMPRODUCT help #7
My question is if I have 3 or 4 criteria that need to be met before
excel acknowledges the row and then once it does it will sum the
accepted rows and return that sum into another sheet.
Category Price Date Customer #
InorgStock $30.00 10/20/2005101643
Inorg CB $415.80 1/23/2006 109597
InorgStock $15.00 1/23/2006 101643
Matrix Mod $50.00 1/23/2006 101643
If I want excel to only add up the extended price for the columns that
met the criteria Customer Number=101643 and Category=inorgstock and
Category=Inorg CB and Category=Matrix Mod and Document Date is
>=10/20/05 but <...Help Required with Macro to Manipulate Data
I have a spreadsheet(s) with the following data on it (this is imported
from a text file)
A B C D
1 Branch Date Total
2 4501 030204 29
4 4501 030204 14
6 4502 030204 331
8 4502 030204 52
10 4503 030204 54
12 4503 030204 85
and what do you want to achieve :-)
"Alan T >" <<Alan.T.firstname.lastname@example.org> schrieb im
> I have a spreadsheet(s) with the following data on it (this is
...Using Rept function
I want to repeat one cells entry somewhere else in my (same) worksheet and have used the Rept function successfully. However, ifthe 1st cell (e.g. A3 is in date format like 12/12/2003, when I use the Rept A3,1 function in another cell (e.g.cell R3), it returns the date as a number (37967). What I want is for the date to be repeated exactly as is (12/12/2003 or whatever date is typed).
Can anyone help please
Don't use the REPT function. Just enter =A3 and apply the date format you
want using Format, Cells if you do not automatically get it.
You can't unless ...