Sum/Auto Calc function sums everything to Zero - Excel freez

AnitaRochester

New Member
Joined
Oct 5, 2006
Messages
2
MS Excel 2002 SP3

Issues I have been having:
- sum/auto calc sums everything to Zero (sometimes it works and others doesn't and this is the case for any file or brand new worksheet I work on)
* the same worksheet I send to another person and does the calculations normally, thus nobody is able to recreate my problem on their system
* in rare cases I am able to copy the worksheet into a new workbook and the functions work (can't do that when it's linked to other tabs)
*if i just move the worksheet to a new workbook it still doesn't work
* other times, I reenter the sum formulas and they work, but next time I open a the workbook and change one of the dependent cells the other one with function does not get updated
- randomly it freezes up and shuts down and restarts again especially when I try to save the work I did

Already did:
- reinstalled excel
- worked with one workbook at the time as much as I can (so no pattern of having a corruptted file open)
- restarting the computer sometimes helps
- under Calculation Options I do have the Automatic Calculation selected
as well as Update remote refrences and Save external link values

I really don't know what else could be wrong. Can you help?
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Forum statistics

Threads
1,141,134
Messages
5,704,480
Members
421,353
Latest member
jekoxien15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top