Excell 2016 wants to save even when I haven't made changes

How do I stop Excel 2016 from asking me to save (or not) when I haven't made changes to the file?

Thanks

Answer
Answer

Hi Brian,

I believe, the following article can answer your question: "Save changes in " prompt even if no changes are made

According to the above article, this behavior occurs when something in the file has changed. Many times, the user doesn't realize there are elements in the file that have been updated or calculated. Here are some examples of common scenarios: 

  • There is a volatile function used in the file. Examples of volatile formulas are listed in the more information section of this article.
  • The file has been opened in a newer version and formulas have been calculated. See article in the more information section.
  • A formula that contains a link to a formula in another workbook and that uses volatile functions
  • Linked pictures
  • Iterative formulas
  • Charts that are on chart sheets or that are embedded into worksheets but that have their source data in another workbook
  • VBA code that updates the workbook

Thanks,

Neha

-------------------------
* Beware of scammers posting fake support numbers here.

* Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here.

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated December 8, 2020 Views 256 Applies to: