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