Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get "File Close" to prompt me to "Save Changes" ??
Hi all. In XL95, when I do File Close, it prompts me "Save changes in.....xls ??
In XL2000 it just vanishes without saving. Please how can I fix this. ? TIA Charles Jordan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get "File Close" to prompt me to "Save Changes" ??
AFAIK there is no option to allow saving unsaved changes to be overridden in
the way you describe. My installation of 2000 exhibits the normal behaviour of prompting if I've made changes but not saved when I try to close the workbook. Perhaps you have the autosave feature turned on and unbeknown to you the workbook is actually being saved in the background? -- Regards, Bill Lunney www.billlunney.com "Charles Jordan" wrote in message om... Hi all. In XL95, when I do File Close, it prompts me "Save changes in.....xls ?? In XL2000 it just vanishes without saving. Please how can I fix this. ? TIA Charles Jordan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get "File Close" to prompt me to "Save Changes" ??
"Bob Phillips" wrote in message ...
Agree with Bill, XL2000 and XL2002 still prompt you to save a changed workbook. -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Bill Lunney" wrote in message ... AFAIK there is no option to allow saving unsaved changes to be overridden in the way you describe. My installation of 2000 exhibits the normal behaviour of prompting if I've made changes but not saved when I try to close the workbook. Perhaps you have the autosave feature turned on and unbeknown to you the workbook is actually being saved in the background? -- Regards, Bill Lunney www.billlunney.com "Charles Jordan" wrote in message om... Hi all. In XL95, when I do File Close, it prompts me "Save changes in.....xls ?? In XL2000 it just vanishes without saving. Please how can I fix this. ? TIA Charles Jordan Bill and Bob - Where can I find out whether the autosave feature is turned on please ? Tks Charles |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get "File Close" to prompt me to "Save Changes" ??
Autosave is an addin in Excel 2000. Look in Tools=Addin. Do you have it
selected? Regards, Tom Ogilvy Charles Jordan wrote in message om... "Bob Phillips" wrote in message ... Agree with Bill, XL2000 and XL2002 still prompt you to save a changed workbook. -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Bill Lunney" wrote in message ... AFAIK there is no option to allow saving unsaved changes to be overridden in the way you describe. My installation of 2000 exhibits the normal behaviour of prompting if I've made changes but not saved when I try to close the workbook. Perhaps you have the autosave feature turned on and unbeknown to you the workbook is actually being saved in the background? -- Regards, Bill Lunney www.billlunney.com "Charles Jordan" wrote in message om... Hi all. In XL95, when I do File Close, it prompts me "Save changes in.....xls ?? In XL2000 it just vanishes without saving. Please how can I fix this. ? TIA Charles Jordan Bill and Bob - Where can I find out whether the autosave feature is turned on please ? Tks Charles |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get "File Close" to prompt me to "Save Changes" ??
Dave Peterson wrote in message ...
IIRC, it's under tools|Autosave. You could look under Tools|Addins to see if the addin were installed, too. Although, it could be installed without being turned on. Charles Jordan wrote: "Bob Phillips" wrote in message ... Agree with Bill, XL2000 and XL2002 still prompt you to save a changed workbook. -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Bill Lunney" wrote in message ... AFAIK there is no option to allow saving unsaved changes to be overridden in the way you describe. My installation of 2000 exhibits the normal behaviour of prompting if I've made changes but not saved when I try to close the workbook. Perhaps you have the autosave feature turned on and unbeknown to you the workbook is actually being saved in the background? -- Regards, Bill Lunney www.billlunney.com "Charles Jordan" wrote in message om... Hi all. In XL95, when I do File Close, it prompts me "Save changes in.....xls ?? In XL2000 it just vanishes without saving. Please how can I fix this. ? TIA Charles Jordan Bill and Bob - Where can I find out whether the autosave feature is turned on please ? Tks Charles Tom - the behaviour I am seeking is not the automatic saving at say 30 minute intervals, which the Autosave add-in probably gives us, but the "want to save? " prompt upon file closure, which might be after say 10 minutes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
is it possible to disable "save" prompt in excel file on web server? | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
Disabling "SAVE AS" option under "File" | Excel Discussion (Misc queries) |