ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I get "File Close" to prompt me to "Save Changes" ?? (https://www.excelbanter.com/excel-programming/272096-how-can-i-get-file-close-prompt-me-save-changes.html)

Charles Jordan

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

Bill Lunney

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




Charles Jordan

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

Tom Ogilvy

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




Charles Jordan

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.


All times are GMT +1. The time now is 05:26 AM.

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