Saving Problem

R

Robert Nguyen

One of my Excel files keeps asking me to save my changes
when I try to close, even though I have already saved it
several times. Has anyone else had this problem? Could
it be something in my VBA code?
 
A

Andy B

Hi

It may be that you have a 'volatile' function in your sheet - such as RAND()
or TODAY() (or many others) which calculate every time you change anything
on the sheet. This will make the sheet believe a change has been made and
ask if you want to save.

Andy.
 
R

Robert Nguyen

Andy,

Problem is ... I save it, then right away close it and it
asks me again.
 
A

Amy

Why would you not just try closing it and it will prompt
to save. Hit Save and it will close right away too. Easy
as that.
 
R

Robert Nguyen

Thanks Amy, but it's not me that I'm worried about. I
created this report for other people, and some of these
people would get nervous for anything that is unusual.
Even as minor as this problem. I'm just trying to prevent
unnecessary questions.
 

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

Similar Threads

Table of content - format does not get saved 2
Can't save my Office documents (after computer rebuild and reauthorization) 0
My Visio2019 Keep Crashed when open the program 0
Excel file won't save to iCloud on Mac 0
Word OLE to check spelling in text box 1
OLE Word spelling 0
Word 2003 won't exit 8
Autonumber field in Excel that behaves the same as Access 0

Top