GS wrote:

One loads a spreadsheet into Excel; never mind there are calculations
(NO macros). Then one exits Excel and gets the CRAP message; never
mind you did NOTHING but look at it. How does one get rid of this
CRAP response?

Any formulas will recalculate automatically and so Excel assumes
changes have been made as a result. If you just want to view, try
opening 'Read Only'!

The OP never mentioned which *version* of Excel he is using. As I
recall, as of Excel 2007, and later, the default setting was not to
auto-calculate on loading a spreadsheet, but in prior versions the
default was to recalculate the formulae on loading the document.

Here's a Youtube video showing how to enable/disable automatic formula
updating.

https://www.youtube.com/watch?v=8WzR6Hds8sw
https://spreadsheeto.com/recalculate...resh-formulas/

The problem with disabling auto-calculate on loading the document is
that cells with formulae won't get updated for other cells whose data
would change on load, like datestamps. The user would need to remember
to hit F9 before he prints an open document to force an immediate recalc
of all formulae; however, users often forget this, so what they print is
indeed what the spreadsheet shows, but not what the formulated cells
should actually be showing to make correct their formulated content.
The problem gets compounded when formulae link between worksheets.