Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing Excel without alert
I asked this question before but realize I was a little vague in my details.
How can I bypass or disable the warning in Excel 2003 that asks if I want to "save changes before closing" when in fact I have made no changes. I have NO formulas in the file that would cause an automatic update. I did an experiment: We have a computer with an older version of excel and I opened an excel file on a shared server, made no changes to the file, and then closed it. No warning appeared. I came to my computer, (with the new Excel 2003), opened the same excel file, made no changes, and closed it. Sure enough the warning alert appeared asking me if I wanted to save changes. This happens on every single excel file I open. Every one! I am wondering if it's not something in the way excel opens. Please someone help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing Excel without alert
Didn't you get a notice when you opened that other file on the pc with the newer
version of excel that excel likes to recalculate when opening workbooks that were saved in older workbooks? (Or words to that effect.) And if excel is recalculating (for any reason), it'll think that the workbook is dirty (mark it as having changed since the last save (or when it was opened)). Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl It might work for you. SLB, accounting wrote: I asked this question before but realize I was a little vague in my details. How can I bypass or disable the warning in Excel 2003 that asks if I want to "save changes before closing" when in fact I have made no changes. I have NO formulas in the file that would cause an automatic update. I did an experiment: We have a computer with an older version of excel and I opened an excel file on a shared server, made no changes to the file, and then closed it. No warning appeared. I came to my computer, (with the new Excel 2003), opened the same excel file, made no changes, and closed it. Sure enough the warning alert appeared asking me if I wanted to save changes. This happens on every single excel file I open. Every one! I am wondering if it's not something in the way excel opens. Please someone help. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing Excel without alert
Excel 2003 notices that a workbook was written in an earlier version of Excel
and asks if you want to re-save in current version. Is this the message you are getting? If so, save the workbook once and the message will stop for that workbook. Gord Dibben MS Excel MVP On Fri, 1 Sep 2006 12:51:02 -0700, SLB, accounting wrote: I asked this question before but realize I was a little vague in my details. How can I bypass or disable the warning in Excel 2003 that asks if I want to "save changes before closing" when in fact I have made no changes. I have NO formulas in the file that would cause an automatic update. I did an experiment: We have a computer with an older version of excel and I opened an excel file on a shared server, made no changes to the file, and then closed it. No warning appeared. I came to my computer, (with the new Excel 2003), opened the same excel file, made no changes, and closed it. Sure enough the warning alert appeared asking me if I wanted to save changes. This happens on every single excel file I open. Every one! I am wondering if it's not something in the way excel opens. Please someone help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing Excel without alert
Is there an addin on your machine with 2003 that could be doing something to
your files, or possibly something in your personal workbook? -- HTH... Jim Thomlinson "SLB, accounting" wrote: I asked this question before but realize I was a little vague in my details. How can I bypass or disable the warning in Excel 2003 that asks if I want to "save changes before closing" when in fact I have made no changes. I have NO formulas in the file that would cause an automatic update. I did an experiment: We have a computer with an older version of excel and I opened an excel file on a shared server, made no changes to the file, and then closed it. No warning appeared. I came to my computer, (with the new Excel 2003), opened the same excel file, made no changes, and closed it. Sure enough the warning alert appeared asking me if I wanted to save changes. This happens on every single excel file I open. Every one! I am wondering if it's not something in the way excel opens. Please someone help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing Excel without alert
I thought it could be that also, so I created a new spreadsheet to test it,
and no, it still asks if I want to save changes. I will check Mr. Thomlinson's question about a possible addin. Other than that, I am at a loss. It's not affecting how excel runs, it's just annoying. Thanks for the response. "Gord Dibben" wrote: Excel 2003 notices that a workbook was written in an earlier version of Excel and asks if you want to re-save in current version. Is this the message you are getting? If so, save the workbook once and the message will stop for that workbook. Gord Dibben MS Excel MVP On Fri, 1 Sep 2006 12:51:02 -0700, SLB, accounting wrote: I asked this question before but realize I was a little vague in my details. How can I bypass or disable the warning in Excel 2003 that asks if I want to "save changes before closing" when in fact I have made no changes. I have NO formulas in the file that would cause an automatic update. I did an experiment: We have a computer with an older version of excel and I opened an excel file on a shared server, made no changes to the file, and then closed it. No warning appeared. I came to my computer, (with the new Excel 2003), opened the same excel file, made no changes, and closed it. Sure enough the warning alert appeared asking me if I wanted to save changes. This happens on every single excel file I open. Every one! I am wondering if it's not something in the way excel opens. Please someone help. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing Excel without alert
Thanks for your response. I will check on this possibility, although I'm not
sure if I know what to look for in addin properties. "Jim Thomlinson" wrote: Is there an addin on your machine with 2003 that could be doing something to your files, or possibly something in your personal workbook? -- HTH... Jim Thomlinson "SLB, accounting" wrote: I asked this question before but realize I was a little vague in my details. How can I bypass or disable the warning in Excel 2003 that asks if I want to "save changes before closing" when in fact I have made no changes. I have NO formulas in the file that would cause an automatic update. I did an experiment: We have a computer with an older version of excel and I opened an excel file on a shared server, made no changes to the file, and then closed it. No warning appeared. I came to my computer, (with the new Excel 2003), opened the same excel file, made no changes, and closed it. Sure enough the warning alert appeared asking me if I wanted to save changes. This happens on every single excel file I open. Every one! I am wondering if it's not something in the way excel opens. Please someone help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
create a pop-up alert when a condition is reached in excel | Excel Discussion (Misc queries) | |||
Excel closing question | Excel Discussion (Misc queries) | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
Excel 2003 - long closing time when have many add-ins installed | Excel Discussion (Misc queries) |