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.