Microsoft Excel Formula Problem

[Guest]

I'm having a rather odd problem with my Excel formulas and hope someone has a
solution.

Within the last month, most of my Excel spreadsheet formulas have simply
stopped working. When I input new data into the sheet, the formula will not
calculate new totals like it did a month ago. Nothing about the formula has
been changed and it is correct. The weird thing is is that it only affects
some of my spreadsheets but not all. I work in an office, networked to other
computers, but we all have our own Excel's (we do not share one off a server)
and several of my co-workers are having this problem too. Along with the
formulas not formulating, I also cannot copy and past them like before. This
makes work life rather difficult for us, so if anyone has any suggestions
they would be greatly appreciated.

Oh, one more thing, we have also installed the latest update for the Windows
XP (service pack 3 perhaps) but the formulas still don't work.

 

[Rock]

I'm having a rather odd problem with my Excel formulas and hope someone
has a
solution.

Within the last month, most of my Excel spreadsheet formulas have simply
stopped working. When I input new data into the sheet, the formula will
not
calculate new totals like it did a month ago. Nothing about the formula
has
been changed and it is correct. The weird thing is is that it only
affects
some of my spreadsheets but not all. I work in an office, networked to
other
computers, but we all have our own Excel's (we do not share one off a
server)
and several of my co-workers are having this problem too. Along with the
formulas not formulating, I also cannot copy and past them like before.
This
makes work life rather difficult for us, so if anyone has any suggestions
they would be greatly appreciated.

Oh, one more thing, we have also installed the latest update for the
Windows
XP (service pack 3 perhaps) but the formulas still don't work.

You should post to an Excel newsgroup. This one is for issues with the XP
OS. Here is a link to one of them. For the others look at
microsoft.public.excel. Good luck.

http://www.microsoft.com/communitie...bba-4f8a-4d9f-b3bb-391f9bb97e27&lang=en&cr=us

 

[Guest]

Try lowering the security level

 

[3c273]

Try changing the format of the cell that contains the formula to general,
then input the formula again. Someone at my work accidentally formatted some
cells that contained formulas as text and they stopped working.
Louis

 

[Gord Dibben]

Not true.


Gord Dibben MS Excel MVP