Prevent pop ups?

[Mike]

Can I disable popups asking to save files? I have sheets that I only
use for data entry and viewing but when they are closed it asks if I
want to save them with their changes. No I don't, can I prevent the
pop up from coming up?

Thanks
Mike

 

[GS]

Mike has brought this to us :

Can I disable popups asking to save files? I have sheets that I only
use for data entry and viewing but when they are closed it asks if I
want to save them with their changes. No I don't, can I prevent the
pop up from coming up?

Thanks
Mike

Excel asks this whenever you open a file that contains formulas. The
formulas are recalced and so the file is flagged as needing to be
saved.

Possible solutions:
- Use VBA code to set its 'Saved' property to 'True'.

- Turn off automatic calculation before you open the file.

- Convert the data to constant values before initial saving.

 

[Gord Dibben]

This occurs when you have formulas that use volatile functions like TODAY and
NOW to mention a couple.

If you can eliminate those functions you will not get the pop-ups.

Non-volatile functions in formulas will not cause the pop-ups unless you
physically/manually change a value.


Gord Dibben MS Excel MVP