Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Document in Excel
Why does excel ask if i want to save a document when i have made no changes?
it happens only with certain workbooks, not all of them. Do I need to change my settings? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Document in Excel
Two possibilities (there may be others)
1. If there is a macro which runs when the file is opened, this effectively changes the file, even if all the data remains the same. 2. If the file was created with an older version of Excel, you will be prompted to save the file. I think in this case the message box tells you why. -- Ian -- "Sam" wrote in message ... Why does excel ask if i want to save a document when i have made no changes? it happens only with certain workbooks, not all of them. Do I need to change my settings? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Document in Excel
I think it is#2. it does not give a reason in the message box however. will
the save message go away if I paste the doc conents in a new worksheeet? "Ian" wrote: Two possibilities (there may be others) 1. If there is a macro which runs when the file is opened, this effectively changes the file, even if all the data remains the same. 2. If the file was created with an older version of Excel, you will be prompted to save the file. I think in this case the message box tells you why. -- Ian -- "Sam" wrote in message ... Why does excel ask if i want to save a document when i have made no changes? it happens only with certain workbooks, not all of them. Do I need to change my settings? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Document in Excel
There is also the case where your sheet contains volatile functions, such
as: Indirect Rand Cell Offset Now Today Info These calculate every time you hit <Enter. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Sam" wrote in message ... I think it is#2. it does not give a reason in the message box however. will the save message go away if I paste the doc conents in a new worksheeet? "Ian" wrote: Two possibilities (there may be others) 1. If there is a macro which runs when the file is opened, this effectively changes the file, even if all the data remains the same. 2. If the file was created with an older version of Excel, you will be prompted to save the file. I think in this case the message box tells you why. -- Ian -- "Sam" wrote in message ... Why does excel ask if i want to save a document when i have made no changes? it happens only with certain workbooks, not all of them. Do I need to change my settings? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Document in Excel
Sam
There are several Volatile Functions. AREAS() OFFSET() CELL() INDIRECT() NOW() TODAY() RAND() Any one or more of these would cause the workbook changes. You can do a Find for these or hit CTRL + `(backquote above Tab key) to toggle View Formulas on and do a look search by eyeball. Gord Dibben MS Excel MVP On Tue, 11 Jul 2006 07:10:02 -0700, Sam wrote: Why does excel ask if i want to save a document when i have made no changes? it happens only with certain workbooks, not all of them. Do I need to change my settings? Gord Dibben MS Excel MVP |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Document in Excel
<<<"These calculate every time you hit <Enter."
I *don't* believe that I typed that!<g -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "RagDyeR" wrote in message ... There is also the case where your sheet contains volatile functions, such as: Indirect Rand Cell Offset Now Today Info These calculate every time you hit <Enter. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Sam" wrote in message ... I think it is#2. it does not give a reason in the message box however. will the save message go away if I paste the doc conents in a new worksheeet? "Ian" wrote: Two possibilities (there may be others) 1. If there is a macro which runs when the file is opened, this effectively changes the file, even if all the data remains the same. 2. If the file was created with an older version of Excel, you will be prompted to save the file. I think in this case the message box tells you why. -- Ian -- "Sam" wrote in message ... Why does excel ask if i want to save a document when i have made no changes? it happens only with certain workbooks, not all of them. Do I need to change my settings? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Document in Excel
It will not be #2 if the message box does not appear stating that "this file was
created with an older version of Excel". Copying to another file will just take the problem over there. See other answers in this thread. Gord Dibben MS Excel MVP On Tue, 11 Jul 2006 07:34:01 -0700, Sam wrote: I think it is#2. it does not give a reason in the message box however. will the save message go away if I paste the doc conents in a new worksheeet? "Ian" wrote: Two possibilities (there may be others) 1. If there is a macro which runs when the file is opened, this effectively changes the file, even if all the data remains the same. 2. If the file was created with an older version of Excel, you will be prompted to save the file. I think in this case the message box tells you why. -- Ian -- "Sam" wrote in message ... Why does excel ask if i want to save a document when i have made no changes? it happens only with certain workbooks, not all of them. Do I need to change my settings? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to merge into an Excel Main Document with Excel Data-How? | Excel Discussion (Misc queries) | |||
editing an excel 97 file within excel 2003 and saving back as exce | Excel Discussion (Misc queries) | |||
Putting Excel Charts into a Word document that's getting too big | Charts and Charting in Excel | |||
existing excel file when clicked opens blank excel document | Excel Discussion (Misc queries) | |||
Help, insert a word document contents into excel tab? | Excel Discussion (Misc queries) |