Calculate message

[Guest]

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 are: 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!

 

[Paul B]

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

 

[Guest]

thanks soooooooooooo much! no more hair pulling for me

 

[Paul B]

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