Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file?
 

Hello.
Every time Ia file is closed in Excel 2007, the program asks if I want
to save any changes made to the file, even if the file was not
modified. This happens even if just viewing an excel attachment in
Outlook.

How do I stop Excel from doing this for files that have not been
modified after openin?

Thanks.

Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file?
 

When Excel opens a file that was generated in an earlier version, it feel
obligated to save to in the new format. Don't think you can switch off this
feature.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"anctech" wrote in message
oups.com...
Hello.
Every time Ia file is closed in Excel 2007, the program asks if I want
to save any changes made to the file, even if the file was not
modified. This happens even if just viewing an excel attachment in
Outlook.

How do I stop Excel from doing this for files that have not been
modified after openin?

Thanks.

Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file?
 

it feel obligated to save to in the new format

I'd put it a little differently. If the workbook was last saved in an older
version of Excel then Excel will automatically calc the workbook when it is
opened (and therefore prompt to save it even if there are no other changes).
Also, if the workbook uses any volatile functions, like OFFSET, Excel will
always calc them and prompt to save.

--
Jim
"Bernard Liengme" wrote in message
...
| When Excel opens a file that was generated in an earlier version, it feel
| obligated to save to in the new format. Don't think you can switch off
this
| feature.
| best wishes
| --
| Bernard V Liengme
| www.stfx.ca/people/bliengme
| remove caps from email
|
| "anctech" wrote in message
| oups.com...
| Hello.
| Every time Ia file is closed in Excel 2007, the program asks if I want
| to save any changes made to the file, even if the file was not
| modified. This happens even if just viewing an excel attachment in
| Outlook.
|
| How do I stop Excel from doing this for files that have not been
| modified after openin?
|
| Thanks.
|
|
|

Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file?
 

Thanks for this - I had forgotten the second part.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jim Rech" wrote in message
...
it feel obligated to save to in the new format

I'd put it a little differently. If the workbook was last saved in an
older
version of Excel then Excel will automatically calc the workbook when it
is
opened (and therefore prompt to save it even if there are no other
changes).
Also, if the workbook uses any volatile functions, like OFFSET, Excel will
always calc them and prompt to save.

--
Jim
"Bernard Liengme" wrote in message
...
| When Excel opens a file that was generated in an earlier version, it
feel
| obligated to save to in the new format. Don't think you can switch off
this
| feature.
| best wishes
| --
| Bernard V Liengme
| www.stfx.ca/people/bliengme
| remove caps from email
|
| "anctech" wrote in message
| oups.com...
| Hello.
| Every time Ia file is closed in Excel 2007, the program asks if I want
| to save any changes made to the file, even if the file was not
| modified. This happens even if just viewing an excel attachment in
| Outlook.
|
| How do I stop Excel from doing this for files that have not been
| modified after openin?
|
| Thanks.
|
|
|

Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file?
 

When Excel opens, the current user is recorded as metadata and the date time
stamp of the file is changed as well. If you dont accept the changes, then
the date time stamp reverts back to what it was previously before you opened
the file.

Saruman

"anctech" wrote in message
oups.com...
Hello.
Every time Ia file is closed in Excel 2007, the program asks if I want
to save any changes made to the file, even if the file was not
modified. This happens even if just viewing an excel attachment in
Outlook.

How do I stop Excel from doing this for files that have not been
modified after openin?

Thanks.