Save changes prompt upon closing file

Davidns

Board Regular
Joined
May 20, 2011
Messages
127
Office Version
  1. 365
Platform
  1. Windows
Why does Excel prompt to save changes when closing a file if no changes have been made? In fact, it doesn't do so consistently with all files, but I do have one file that even if I open it and them immediately close it without doing a thing, it still prompts me that changes have been made.
Should I be concerned? Its a key file for me so just want to make sure I have not done anything to cause unwanted changes.
Thanks!
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,446
Office Version
  1. 365
Platform
  1. Windows
Files that do that quite likely contain one or more volatile functions.
Nothing particularly to worry about. If you know you haven't changed anything it shouldn't matter whether you choose to save or not.

However, if you have macros in the file then it may be possible that they change something when you open the file and in that case presumably you would want to save the changes.
 

Davidns

Board Regular
Joined
May 20, 2011
Messages
127
Office Version
  1. 365
Platform
  1. Windows
Got it. Thank you. Never heard of a volatile function before. Glad to learn something new!! Much appreciated.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,446
Office Version
  1. 365
Platform
  1. Windows
Got it. Thank you. Never heard of a volatile function before. Glad to learn something new!! Much appreciated.
Cheers. Hopefully you can rest easier now. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,129,269
Messages
5,635,198
Members
416,846
Latest member
ImGoing2needaFormula

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top