Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suddenly Save and Save as greyed out in Excel 2003 | Excel Discussion (Misc queries) | |||
Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
'document not saved' for 'save' or 'save as' an EXCEL file | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions |