Calculate 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 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!

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" <[email protected]> wrote in message
news:[email protected]...
> 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!

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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!
>>
>>
>>