Excel “INDIRECT“ function, Save file issue

[siamak_sm]

Hi

I have an issue regarding Excel’s “INDIRECT” function. Actually, I know how to use this function.

My problem is every time I open a workbook including INDIRECT function and then close it, Excel asks if I would like to save changes, while I didn’t make any (I don’t even change a cell, just open the file and immediately close it).

This situation happens on my PC but this not happens on my laptop.

Please note that I don’t use any macro or VBA code in my file.

I’m using Windows 10, Office 2019 on both computers.

Thank you very much.

 

[siamak_sm]

I've searched about alternatives for INDIRECT function. While there are other ways to avoid a volatile INDIRECT function, I found why I got different reactions on different computers.
I discover that I have activated "Analysis Tool Pack" add-in on my PC. By remove "Analysis Tool Pack" and/or "Solver Tool Pack" I got no save changes message anymore.

 

[siamak_sm]

Which is why I replied as I did in post#4

Hi dear Fluff,
Finally I found what's going on.
I send this message to make sure you will see the solution (post #11).
I want to thank you for your time.

 

[Fluff]

Glad you sorted it & thanks for letting us know.