Link to home
Get AccessLog in
Avatar of skyriac
skyriac

asked on

Microsoft Excel 2003 - Formula result always Zero

One of my co-workers is working on a large spreadsheet with a lot of formulas.  It seems that whatever new formula she puts in results in zero.  I tried a brand new worksheet and the same thing happens.  I have gone to Tools..Options and the Calculation tab. It is set to automatic.  I even pressed <f9> and it didn't do any good.  I opened the spreadsheet from another computer and didn't have this problem.  

Any ideas?
ASKER CERTIFIED SOLUTION
Avatar of John
John
Flag of Canada image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Hi Sky,
Sometimes when i don't understand what's going on with my PC , and it starts to annoy me i do system restore ... if you don't know how , here you are :
Click on : Start >> programs >> Accessories >> System tools >> System restore.
And restore your system to an earlier date when your excel sheet was working fine .

PS: this action will not delete any data or documents from your PC even if they were created after the chosen date… so no worries ..

Hope it helps,
Brgds, Wellous
Thank you. I was pleased to assist and hope all is well now. ... Thinkpads_User