Excel falsely asks me to save!

  • Thread starter Thread starter Julie P.
  • Start date Start date
J

Julie P.

Everytime I open a certain Excel doc, even if no changes are made, it asks
me if I want to save when I close it! Even if I open it and instantly decide
to close it!

Why does it do this and how do I get it to stop?

Thanks!
 
You have an automatic calculation event such as =now() or =today() that
would cause this.
In the ThisWorkbook module you could use
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.Saved = True
End Sub
 
Do you have any formulas in it, if so that is the reason

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()
 
Peo Sjoblom said:
Do you have any formulas in it, if so that is the reason

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()
Click to expand...


Hi, thanks Don and Peo!

I checked, and the only formulae I have are

sum
counta
counta(indirect)

so it must be the indirect that is causing it! Thanks!
 
Back
Top