Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving Prompts
Hi Hope this isn't a dumb question... When I exit a workbook , Excel is asking me if I'd like to save changes , even when I haven't made any! Sometimes I have several open and it's a pain to be asked this for every single one. I need to be asked if I want to save when I've made a change , but don't need it when I haven't... Is there anyway I can switch this off? Best Wishes Colin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving Prompts
Colin, Some functions in excel are "volatile", they will re-calculate every
time excel is opened, this will make the worksheet change even if you don't make any changes. Have a look here for a list Volatile Functions http://www.decisionmodels.com/calcsecretsi.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Colin Hayes" wrote in message ... Hi Hope this isn't a dumb question... When I exit a workbook , Excel is asking me if I'd like to save changes , even when I haven't made any! Sometimes I have several open and it's a pain to be asked this for every single one. I need to be asked if I want to save when I've made a change , but don't need it when I haven't... Is there anyway I can switch this off? Best Wishes Colin |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving Prompts
In article , Paul B
writes Colin, Some functions in excel are "volatile", they will re-calculate every time excel is opened, this will make the worksheet change even if you don't make any changes. Have a look here for a list Volatile Functions http://www.decisionmodels.com/calcsecretsi.htm Hi Paul OK thanks I had a look at the article. My problems is that this seems to happen with EVERY file I open. I can open a workbook and then close immediately and I get this message asking me if I'd like to save my changes. This happens always - even with the simplest ones. I understand the issue of volatility , but I think maybe I have something set somewhere which is causing this. Best Wishes Colin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print prompts save as | New Users to Excel | |||
Prompts | Excel Discussion (Misc queries) | |||
When saving CSV excel always prompts about the file format | Excel Discussion (Misc queries) | |||
How do i set up a range of numbers which prompts at a particular n | Excel Discussion (Misc queries) | |||
formula prompts | Excel Discussion (Misc queries) |