Why is it when closing certain files that I’m prompted to save when I haven’t changed a thing?

This question was posted earlier about a month ago from someone else and the response didn’t explain anything.

I understand why certain functions such as TODAY() and NOW() would require the save dialog to pop up on closing but why INDIRECT, OFFSET or CELL ect., what’s happening with these functions? I don’t get it.

Matt