Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Xcel sheet saves

Copper Contributor

Why does one particular sheet always require me to save it whenever I access it (even though I know that I saved it the last time I used it?)

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@ELLIOTT_LAWRENCE 

There are formulas that will automatically be recalculated when you open the workbook. An example is

 

=NOW()

 

So even if you don't change anything yourself, the workbook will always be modified. Hence the prompt.

Thank you.
1 best response

Accepted Solutions
best response confirmed by Sergei Baklan (MVP)
Solution

@ELLIOTT_LAWRENCE 

There are formulas that will automatically be recalculated when you open the workbook. An example is

 

=NOW()

 

So even if you don't change anything yourself, the workbook will always be modified. Hence the prompt.

View solution in original post