Prevent pop ups?

M

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
 
G

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top