Why did Excel ask me if I want to save?

  • Thread starter Thread starter netcomm888
  • Start date Start date
N

netcomm888

This is kinda annyoying. I opened the excel file and didn't do anything
and immediately closed it. However, Excel asked me if I want to save
the changes?
Anybody knows why this could happen. There is no macro in the file,
although it has a few combo boxes. Could that be a problem?
Thanks in advance
 
Any time you have a volatile function (e.g., NOW(), RAND(), TODAY(),
INDIRECT(),OFFSET(),ROWS(),COLUMNS(),CELL()), and the sheet is
calculated when opened, it will mark the file as being changed and
needing to be saved.
 
Wow, that's a quick response. Thanks a lot. This new version of Google
groups is also much better than the previous one, in that I don't have
to wait hours to see my message posted.

JE, although I did not have any function you mentioned above, there are
some comboboxes in the file. I did some further tests, by deleting
them. It proves that those combo boxes is the reason.

happy holidays!
 

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

Back
Top