Well that little "=" trick helped ME out. I lose my calculations/links when
I move a sheet from one position to another within the workbook. I still
don't know why that happens or how to prevent it but at least I can repair it
now. Thanks!!
"Dave Peterson" wrote:
How do you know that it's not calculating?
If it's just the statusbar warning, maybe...
http://support.microsoft.com/default.aspx?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula References
ps. What does "cells don't formulate" mean?
One more way that might "kick start" excel.
Select all the worksheets (click on the leftmost tab and shiftclick on the
rightmost tab),
then edit|replace
what: = (equal sign)
with: =
replace all
Then rightclick on any worksheet and ungroup the sheets.
CJ wrote:
Our new network administrator tried to keep all company computers from going
on the internet, and in doing so he royally screwed up several spreadsheets
on my computer ... He eventually had to buy me a new computer, but one
spreadsheet still will not calculate ...
I've tried everything I know to get it to work ... All formula cells that
were calculating previous to his blooper still have data in them ... every
cell since then is not working ... and even with the new computer, the cells
don't formulate ...
HELP ...!!!
--
Dave Peterson