ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why did Excel ask me if I want to save? (https://www.excelbanter.com/excel-programming/319537-why-did-excel-ask-me-if-i-want-save.html)

[email protected]

Why did Excel ask me if I want to save?
 
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


JE McGimpsey

Why did Excel ask me if I want to save?
 
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.

In article .com,
wrote:

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


[email protected]

Why did Excel ask me if I want to save?
 
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!



All times are GMT +1. The time now is 07:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com