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

[anctech]

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.

 

[Bernard Liengme]

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

 

[Jim Rech]

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
| 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
|
| | > 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.
| >
|
|

 

[Bernard Liengme]

Thanks for this - I had forgotten the second part.

 

[Saruman]

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