Hello -

I'm working in Excel and have calculation set to automatic and there are no
circular references in my spreadsheet. Yet it says "Calculate" on the
message bar. I can hit F9 til doomsday but the message doesn't goes away.
If I make a change in the spreadsheet, though, I still do need to hit F9
multiple times for the changes to be effective. So, my questions a a) why
do I need to hit F9 if I'm set to auto calc and b) why won't the calculate
message go away after I F9 or alternatively, "calc spreadsheet". HELP?!?!
Thank you!

Kelly, have a look at these sites

http://www.decisionmodels.com/calcsecretsf.htm



Also:
http://support.microsoft.com/default.aspx?scid=243495

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Kelly" wrote in message
...
Hello -

I'm working in Excel and have calculation set to automatic and there are
no
circular references in my spreadsheet. Yet it says "Calculate" on the
message bar. I can hit F9 til doomsday but the message doesn't goes away.
If I make a change in the spreadsheet, though, I still do need to hit F9
multiple times for the changes to be effective. So, my questions a a)
why
do I need to hit F9 if I'm set to auto calc and b) why won't the calculate
message go away after I F9 or alternatively, "calc spreadsheet". HELP?!?!
Thank you!

thanks soooooooooooo much! no more hair pulling for me :)

"Paul B" wrote:

Kelly, have a look at these sites

http://www.decisionmodels.com/calcsecretsf.htm



Also:
http://support.microsoft.com/default.aspx?scid=243495

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Kelly" wrote in message
...
Hello -

I'm working in Excel and have calculation set to automatic and there are
no
circular references in my spreadsheet. Yet it says "Calculate" on the
message bar. I can hit F9 til doomsday but the message doesn't goes away.
If I make a change in the spreadsheet, though, I still do need to hit F9
multiple times for the changes to be effective. So, my questions a a)
why
do I need to hit F9 if I'm set to auto calc and b) why won't the calculate
message go away after I F9 or alternatively, "calc spreadsheet". HELP?!?!
Thank you!

Your Welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Kelly" wrote in message
...
thanks soooooooooooo much! no more hair pulling for me :)

"Paul B" wrote:

Kelly, have a look at these sites

http://www.decisionmodels.com/calcsecretsf.htm



Also:
http://support.microsoft.com/default.aspx?scid=243495

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Kelly" wrote in message
...
Hello -

I'm working in Excel and have calculation set to automatic and there
are
no
circular references in my spreadsheet. Yet it says "Calculate" on the
message bar. I can hit F9 til doomsday but the message doesn't goes
away.
If I make a change in the spreadsheet, though, I still do need to hit
F9
multiple times for the changes to be effective. So, my questions a
a)
why
do I need to hit F9 if I'm set to auto calc and b) why won't the
calculate
message go away after I F9 or alternatively, "calc spreadsheet".
HELP?!?!
Thank you!