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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anctech - 26 Mar 2007 17:05 GMT

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.

Reply to this Message

Bernard Liengme - 26 Mar 2007 17:39 GMT

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

Signature

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
[quoted text clipped - 6 lines]
>
> Thanks.

Reply to this Message

Jim Rech - 26 Mar 2007 17:52 GMT

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

Signature

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
[quoted text clipped - 10 lines]
| >
| > Thanks.

Reply to this Message

Bernard Liengme - 26 Mar 2007 18:03 GMT

Thanks for this - I had forgotten the second part.

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>>>it feel obligated to save to in the new format
>
[quoted text clipped - 23 lines]
> | >
> | > Thanks.

Reply to this Message

Saruman - 15 Jun 2007 10:42 GMT

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

> Hello.
> Every time Ia file is closed in Excel 2007, the program asks if I want
[quoted text clipped - 6 lines]
>
> Thanks.

Reply to this Message