Excel falsely asks me to save!

[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!

 

[Don Guillett]

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

 

[Peo Sjoblom]

Do you have any formulas in it, if so that is the reason

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()

 

[Julie P.]

Do you have any formulas in it, if so that is the reason

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()

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!

 

[Don Guillett]

glad to help