Weird Excel Behavior When Saving

B

btipton

I am hoping and praying someone has heard of this happening before.
When ever I go to save an Excel workbook, when i click save all th
formulas recalculate doubling the original totals. For example, if
had A1 10 A2 10 and A3 the SUM formula to ad A1 and A2.... it woul
say 20.... but when i click save to save the document... the 20 change
to 40. I am very confused by this. Also, whenever i attach Exce
documents to emails, they never get delievered. I am not havin
problems with other attachments, but for some reason, excel files jus
disappear whenever i send them to someone.

Please Help Me! :eek
 
F

Frank Kabel

Hi
this sounds very strange. The only thing I could imagine for your first
issue is that you have turned off automatic calculation and Excel
re-calculates before saving
 
D

Dave Peterson

You may also have an event macro running.

Try this:
close excel
reopen excel in safe mode
windows start button|run
excel /safe
file|open your workbook

Try saving it.

If this works (and it's not the calculating with circular references), then try
to find the developer and show them the problem and how it doesn't happen in
Safe mode.
 
Top