+ Reply to Thread
Results 1 to 5 of 5

Save changes Prompt when there is no change

  1. #1
    Forum Contributor
    Join Date
    01-14-2004
    Location
    India
    MS-Off Ver
    365
    Posts
    264

    Save changes Prompt when there is no change

    Hi...
    I had a file 2003 version and I saved as macro enabled file in 2010 version. Now if I opened the file and tried to close without doing any change still asking "do you want to save change" where I have not done any changes. This keep coming.. Can someone tell me the reason and what to be done to get rid of this prompt when there is no changes.
    Thanks for sharing your experience..
    Good day
    Appreciate clicking the * Add Reputation button on your left side, if you want say thanks to me

  2. #2
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: Save changes Prompt when there is no change

    Your spreadsheet could have info e.g. =TODAY() that changes data within the spreadsheet? I have searched the internet and so far no other solution. It's no comfort to you but I too get annoyed when this feature pops up when you open and close a spreadsheet, so it's a good question and one I shall continue looking into!

    Cheers,

  3. #3
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: Save changes Prompt when there is no change

    have a look here: http://support.microsoft.com/kb/274500

  4. #4
    Forum Contributor
    Join Date
    01-14-2004
    Location
    India
    MS-Off Ver
    365
    Posts
    264

    Re: Save changes Prompt when there is no change

    I had a INDIRECT formula used in the sheet...that was the reason.. Hope this information will help someone in the forum.. Thanks everyone who contributed to this thread.

  5. #5
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: Save changes Prompt when there is no change

    Well done SMILE - if I have helped you please click on the 'Star' "Add Reputation" on my post.

    Thanks for the feedback and pleased to help.

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro with cell reference as a name, but prompt for save location and save as csv
    By tomham in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2012, 06:21 PM
  2. Save As prompt
    By solnajeff in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2007, 08:49 AM
  3. Save Changes Prompt
    By ExcelQuestion in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-20-2006, 06:25 PM
  4. Replies: 1
    Last Post: 02-24-2006, 10:15 PM
  5. Save Prompt
    By LJuszkiewicz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-27-2005, 02:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1