Prompt to save when no changes made

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: POWER CERTS (POWERCERTS_at_discussions.microsoft.com)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 09:59:03 -0800

I have a file that was coverted from 1997 version of excel to the 2003
version of excel. The file has no volitile functions (eg. "now" formula,
"offset" etc), however I am prompted to save changes on closing the file,
even when no changes were made. I am on automatic calculation, but this
ususally has no effect on the save prompt.

How do I stop Excel from prompting to save when no changes were made?

Thanks

Relevant Pages

  • Re: Nag message on excel installation with Vista
    ... The old ways are still the best; lovely to use the command ... nag screens in Excel now. ... Havn't found Start/Run in Vista but the comand prompt can be accessed frm ... "Dave Peterson" wrote in message ...
    (microsoft.public.excel.setup)
  • Re: Cell >255 Character - Error Mail merge to MS word.
    ... I have tried the suggestion you have given but the situation did not ... The only prompt that prop. ... Delete the headers in the Excel File. ... I am kind of newbee for with database with large amount of info..... ...
    (microsoft.public.excel.misc)
  • Re: Auto close the prompt & dialog boxes
    ... clears the clipboard if it holds a range copied from Excel. ... ' code that would produce a prompt ... >> open another workbook to paste the data on one of the sheet. ... >> the user if he wants to save or clear the data in the clipboard. ...
    (microsoft.public.excel.programming)
  • Re: Save? prompt when closing Excel
    ... Try opening excel in safe mode: ... > workbook on anther users machine I do get prompted. ... > prompt to save change on close" ...
    (microsoft.public.excel.misc)
  • Re: Database Querry
    ... > Now, go to data menu, Get External Data, New Database Query. ... > When done return the data to Excel. ... > prompt for Date1 and Date2; for now you can put anything in there. ...
    (microsoft.public.excel.programming)