Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Have you come up with any conclusions?
I have three laptops all expeirencing the same symptoms. I am starting to believe that there is a registry entry that is set wrong. For instance, I can take a workbook open it in one machine make a change and then close it and it will not save nor propmt to save changes, If I open this workbook on anther users machine I do get prompted. Even a clean fresh documnet that i type HELLO in the first space, "will not prompt to save change on close" I have not been able to find any signs of macros running. MC "lh" wrote: I don't know for sure what happened. I'll just have to keep an eye out and hope I don't miss something. Thanks -----Original Message----- I've never seen excel not ask when it thought the workbook was changed. (A developer could hide this question with a small macro-- could that have happened?) My first guess is you really saved your data--but you saved it to a different location. Any chance???? lh wrote: Over the last couple of days, I've lost changes to some excel files because it is no longer asking me if I want to save the changesI think it used to) when I close the workbook. This isn't the same as AutoSave. What might I have inadvertentely changed. -- Dave Peterson . |
#2
![]() |
|||
|
|||
![]()
Try opening excel in safe mode:
close excel windows start button|run excel /safe Then test it by entering "hello" in A1 and see if you get prompted. If you do, then I'd bet you do have a macro running. Chip Pearson has some notes that you may want to read to help isolate the problem: http://www.cpearson.com/excel/StartupErrors.htm MC wrote: Have you come up with any conclusions? I have three laptops all expeirencing the same symptoms. I am starting to believe that there is a registry entry that is set wrong. For instance, I can take a workbook open it in one machine make a change and then close it and it will not save nor propmt to save changes, If I open this workbook on anther users machine I do get prompted. Even a clean fresh documnet that i type HELLO in the first space, "will not prompt to save change on close" I have not been able to find any signs of macros running. MC "lh" wrote: I don't know for sure what happened. I'll just have to keep an eye out and hope I don't miss something. Thanks -----Original Message----- I've never seen excel not ask when it thought the workbook was changed. (A developer could hide this question with a small macro-- could that have happened?) My first guess is you really saved your data--but you saved it to a different location. Any chance???? lh wrote: Over the last couple of days, I've lost changes to some excel files because it is no longer asking me if I want to save the changesI think it used to) when I close the workbook. This isn't the same as AutoSave. What might I have inadvertentely changed. -- Dave Peterson . -- Dave Peterson |
#3
![]() |
|||
|
|||
![]()
Thanks, but that did not work.
Safe mode -- did not get prompted. Tried Excel.exe /RegServer did not work. Just got a little closer --- Unistalled the SAP Business ONE Outlook Integration and the problem went away.... Boy does this smell like a registry issue. Marty "Dave Peterson" wrote: Try opening excel in safe mode: close excel windows start button|run excel /safe Then test it by entering "hello" in A1 and see if you get prompted. If you do, then I'd bet you do have a macro running. Chip Pearson has some notes that you may want to read to help isolate the problem: http://www.cpearson.com/excel/StartupErrors.htm MC wrote: Have you come up with any conclusions? I have three laptops all expeirencing the same symptoms. I am starting to believe that there is a registry entry that is set wrong. For instance, I can take a workbook open it in one machine make a change and then close it and it will not save nor propmt to save changes, If I open this workbook on anther users machine I do get prompted. Even a clean fresh documnet that i type HELLO in the first space, "will not prompt to save change on close" I have not been able to find any signs of macros running. MC "lh" wrote: I don't know for sure what happened. I'll just have to keep an eye out and hope I don't miss something. Thanks -----Original Message----- I've never seen excel not ask when it thought the workbook was changed. (A developer could hide this question with a small macro-- could that have happened?) My first guess is you really saved your data--but you saved it to a different location. Any chance???? lh wrote: Over the last couple of days, I've lost changes to some excel files because it is no longer asking me if I want to save the changesI think it used to) when I close the workbook. This isn't the same as AutoSave. What might I have inadvertentely changed. -- Dave Peterson . -- Dave Peterson |
#4
![]() |
|||
|
|||
![]()
I don't have any other guess.
But I would take another look at the XLStart folder. And anything that's in the folder specified in: Tools|options|General tab, "at startup, open all files in:" <xl2002+ wording "Alternate Startup File location" <before xl2002 wording Or even Tools|Addins. But those were mentioned in Chip's instructions. I've never seen excel not prompt me when it thought the workbook was dirty -- except when I had a macro running that told excel to do something different. MC wrote: Thanks, but that did not work. Safe mode -- did not get prompted. Tried Excel.exe /RegServer did not work. Just got a little closer --- Unistalled the SAP Business ONE Outlook Integration and the problem went away.... Boy does this smell like a registry issue. Marty "Dave Peterson" wrote: Try opening excel in safe mode: close excel windows start button|run excel /safe Then test it by entering "hello" in A1 and see if you get prompted. If you do, then I'd bet you do have a macro running. Chip Pearson has some notes that you may want to read to help isolate the problem: http://www.cpearson.com/excel/StartupErrors.htm MC wrote: Have you come up with any conclusions? I have three laptops all expeirencing the same symptoms. I am starting to believe that there is a registry entry that is set wrong. For instance, I can take a workbook open it in one machine make a change and then close it and it will not save nor propmt to save changes, If I open this workbook on anther users machine I do get prompted. Even a clean fresh documnet that i type HELLO in the first space, "will not prompt to save change on close" I have not been able to find any signs of macros running. MC "lh" wrote: I don't know for sure what happened. I'll just have to keep an eye out and hope I don't miss something. Thanks -----Original Message----- I've never seen excel not ask when it thought the workbook was changed. (A developer could hide this question with a small macro-- could that have happened?) My first guess is you really saved your data--but you saved it to a different location. Any chance???? lh wrote: Over the last couple of days, I've lost changes to some excel files because it is no longer asking me if I want to save the changesI think it used to) when I close the workbook. This isn't the same as AutoSave. What might I have inadvertentely changed. -- Dave Peterson . -- Dave Peterson -- Dave Peterson |
#5
![]() |
|||
|
|||
![]()
I have been experiencing the same problem as "MC" (in fact I just posted a
note on this today (march 12, 2005). It is interesting that I also have installed SAP Business One - Outlook Integration on my system, likely around the time that this problem started happening with my Excel. That is a very interesting coincidence which I will be following up on . Thanks .... Ron Pender "Dave Peterson" wrote: I don't have any other guess. But I would take another look at the XLStart folder. And anything that's in the folder specified in: Tools|options|General tab, "at startup, open all files in:" <xl2002+ wording "Alternate Startup File location" <before xl2002 wording Or even Tools|Addins. But those were mentioned in Chip's instructions. I've never seen excel not prompt me when it thought the workbook was dirty -- except when I had a macro running that told excel to do something different. MC wrote: Thanks, but that did not work. Safe mode -- did not get prompted. Tried Excel.exe /RegServer did not work. Just got a little closer --- Unistalled the SAP Business ONE Outlook Integration and the problem went away.... Boy does this smell like a registry issue. Marty "Dave Peterson" wrote: Try opening excel in safe mode: close excel windows start button|run excel /safe Then test it by entering "hello" in A1 and see if you get prompted. If you do, then I'd bet you do have a macro running. Chip Pearson has some notes that you may want to read to help isolate the problem: http://www.cpearson.com/excel/StartupErrors.htm MC wrote: Have you come up with any conclusions? I have three laptops all expeirencing the same symptoms. I am starting to believe that there is a registry entry that is set wrong. For instance, I can take a workbook open it in one machine make a change and then close it and it will not save nor propmt to save changes, If I open this workbook on anther users machine I do get prompted. Even a clean fresh documnet that i type HELLO in the first space, "will not prompt to save change on close" I have not been able to find any signs of macros running. MC "lh" wrote: I don't know for sure what happened. I'll just have to keep an eye out and hope I don't miss something. Thanks -----Original Message----- I've never seen excel not ask when it thought the workbook was changed. (A developer could hide this question with a small macro-- could that have happened?) My first guess is you really saved your data--but you saved it to a different location. Any chance???? lh wrote: Over the last couple of days, I've lost changes to some excel files because it is no longer asking me if I want to save the changesI think it used to) when I close the workbook. This isn't the same as AutoSave. What might I have inadvertentely changed. -- Dave Peterson . -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2000 Auto Save | Excel Worksheet Functions | |||
Save prompt when no changes made | Excel Discussion (Misc queries) | |||
I used Save instead of Save As in Excel. How can I get my origin. | Excel Discussion (Misc queries) | |||
auto save in office excel 2003 | Excel Discussion (Misc queries) | |||
How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) |