ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Closing Files (https://www.excelbanter.com/excel-discussion-misc-queries/108118-closing-files.html)

Diana Heimberger

Closing Files
 
When I close some files it asks me if I want to save even if I didn't make
changes to it. I can't figure out why it does it on some files and not
others. Any help would be appreciated. Thanks.

stevebriz

Closing Files
 
Do you ahve any forumula in the work sheet that update automatically
cells when the sheet is open? or reference to todays date in the
footers?
Diana Heimberger wrote:
When I close some files it asks me if I want to save even if I didn't make
changes to it. I can't figure out why it does it on some files and not
others. Any help would be appreciated. Thanks.



Diana Heimberger

Closing Files
 
I do have formulas in there. By the question you asked I assume there is no
way to stop it from asking that question everytime I close the file. Is that
right?

"stevebriz" wrote:

Do you ahve any forumula in the work sheet that update automatically
cells when the sheet is open? or reference to todays date in the
footers?
Diana Heimberger wrote:
When I close some files it asks me if I want to save even if I didn't make
changes to it. I can't figure out why it does it on some files and not
others. Any help would be appreciated. Thanks.




stevebriz

Closing Files
 
I think you would have to turn auto caluculation off
Diana Heimberger wrote:
I do have formulas in there. By the question you asked I assume there is no
way to stop it from asking that question everytime I close the file. Is that
right?

"stevebriz" wrote:

Do you ahve any forumula in the work sheet that update automatically
cells when the sheet is open? or reference to todays date in the
footers?
Diana Heimberger wrote:
When I close some files it asks me if I want to save even if I didn't make
changes to it. I can't figure out why it does it on some files and not
others. Any help would be appreciated. Thanks.






All times are GMT +1. The time now is 02:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com