View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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.
|
|
|