This link explains four things that will cause the "Calculate" message
to be seen on the status bar:

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

Hope this helps.

Pete

On Apr 25, 4:34*pm, Brandon wrote:
I am an advanced excel user. *I have used excel on a daily basis for over 15
years now. * I work in accounting. * Recently in the past year I have been an
excel error that I have never seen before.

It occurs when I am pasting information from one excel sheet into another. *
I will paste into a column of numbers in the destination spreadsheet and the
calculation notifier will appear in the bottom left hand of my screen as if I
had the worksheet set to "manual" calculation. *However, I have it in
automatic calculation. *Even when this error appears, if I go to
Tool/Options, the spreadsheet will show that I have the calculation set to
Automatic. *If I hit F9, the calculation will not update. *For example if I
pasted $140 in cell A1, and $200 in cell A2, the calculation in cell A3 *
=SUM(A1:A2) would give a zero result. *"calculation" would appear in the
bottom left hand screen, and hitting F9 does not accomplish anything. *The
only way to correct this issue would be to shut down office completely. *
Reopen the spreadsheet and the calculation appears to have resolved itself..

A few other things that I have observed:

- This appears to happen randomly. *Without a particular event occuring to
cause it. *For the past year, it happens 2 - 3 times a month.

- I have even gone as far to doing a reinstall of the image on my machine to
correct this and it still occurs.

- It has only been happening to me. *Its not happening to other users in our
group. *

-Which leads me to believe that perhaps its a function that I am using that
others are not. *Perhaps its because I always use the "Ctrl" keys to copy and
paste. *Perhaps its because I leave my computer in standby overnight when
others do not. *Perhaps its because I utilize software that is open in the
background that others do not have installed on their computer.

-For example, it just happened with a spreadsheet that an employee emailed
to me. *I showed the employee the calculation error. *He stated that he never
experience the issue on his computer. *We have the same version of excel
installed. *Excel 2003 (11.8169.8172) SP 3. *

I found article 950340 which seems to discuss the error I am having but it
was for service pack 2. *I have service pack 3 so it should have been
corrected. *The other issue is that everyone else in my group has the same
version, but are not getting the issue. *It leads me to believe I am using
some functionality that others are not utilizing which is the catalyst for
this "bug". *In the 15 years I have been using excel I have never seen
anything like this until this past year. *