Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
No "save changes" when exiting Excel 2003
I have a client using Office 2003, Win XP.
When the close Excel, they are no longer being prompted to "save changes" even though they have made changes. Needless to say, they are quite upset since they are losing the changes they made unless they manually save the file before closing. I have searched and have not been able to find any reference to this. Any help would be greatly appreciated. Jim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
No "save changes" when exiting Excel 2003
JimR,
Are you familiar with VBA and using the VBE. If so, open the VBE, display the Immediate window, enter the following line of code and hit enter: msgbox application.DisplayAlerts If a message box pops up that says "FALSE" then enter the following line and hit enter. application.DisplayAlerts = True If the message box said "TRUE", then I don't know what else it could be.........sorry! HTH, Conan "JimR" wrote in message ... I have a client using Office 2003, Win XP. When the close Excel, they are no longer being prompted to "save changes" even though they have made changes. Needless to say, they are quite upset since they are losing the changes they made unless they manually save the file before closing. I have searched and have not been able to find any reference to this. Any help would be greatly appreciated. Jim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
No "save changes" when exiting Excel 2003
Conan,
An AMAZING little tidbit of info. Can't thank you enough. This helped us narrow down the problem. This only occurs when using info exported from Act. When you check the spreadsheet created by an Act export, the value is in fact false. All I need to do now is figure out how/why Act does this. I suspect they are using an Excel template with this setting set to false by default. Thank you!! "Conan Kelly" wrote: JimR, Are you familiar with VBA and using the VBE. If so, open the VBE, display the Immediate window, enter the following line of code and hit enter: msgbox application.DisplayAlerts If a message box pops up that says "FALSE" then enter the following line and hit enter. application.DisplayAlerts = True If the message box said "TRUE", then I don't know what else it could be.........sorry! HTH, Conan "JimR" wrote in message ... I have a client using Office 2003, Win XP. When the close Excel, they are no longer being prompted to "save changes" even though they have made changes. Needless to say, they are quite upset since they are losing the changes they made unless they manually save the file before closing. I have searched and have not been able to find any reference to this. Any help would be greatly appreciated. Jim |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
No "save changes" when exiting Excel 2003
JimR,
Act probably is running some code (macro) to export to XL. Normally developers will toggle settings like these off & on in the code. Near the beginning would be a command like this: application.DisplayAlerts = FALSE and there should be a command like this near the end of the code: application.DsiplayAlerts = TRUE Now, the code that ACT is using either doesn't have the second command turning the setting back on (not very likely), or an error occurs during execution that stops the execution so the second command doesn't get executed, thus leaving the setting turned off. Also, there could be error traping in the code that bypasses the second command when an error occurs, thus leaving the setting turned off. HTH, Conan "JimR" wrote in message ... Conan, An AMAZING little tidbit of info. Can't thank you enough. This helped us narrow down the problem. This only occurs when using info exported from Act. When you check the spreadsheet created by an Act export, the value is in fact false. All I need to do now is figure out how/why Act does this. I suspect they are using an Excel template with this setting set to false by default. Thank you!! "Conan Kelly" wrote: JimR, Are you familiar with VBA and using the VBE. If so, open the VBE, display the Immediate window, enter the following line of code and hit enter: msgbox application.DisplayAlerts If a message box pops up that says "FALSE" then enter the following line and hit enter. application.DisplayAlerts = True If the message box said "TRUE", then I don't know what else it could be.........sorry! HTH, Conan "JimR" wrote in message ... I have a client using Office 2003, Win XP. When the close Excel, they are no longer being prompted to "save changes" even though they have made changes. Needless to say, they are quite upset since they are losing the changes they made unless they manually save the file before closing. I have searched and have not been able to find any reference to this. Any help would be greatly appreciated. Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I change Excel 2003 default "save to" folder? | Setting up and Configuration of Excel | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
Excel 2003 - Save As function inserts "Copy of" | Excel Discussion (Misc queries) | |||
What has happened to "Save As" in Excel 2003 | Excel Worksheet Functions |