issue with Excel and saving

[sir42]

I've been working with a particular Excel file that always open up "unsaved." Most Excel files I've worked with don't need to be saved until I make a change to them, but this file always up and needs to be saved.

Is there a link or circular function hiding somewhere in the file that needs to be corrected? If so, how might I find it?

thanks!

 

[campyguy]

Is there some automatic recalculation going on in the workbook? If there is automatic recalculation happening - for instance, use of the =TODAY() Function or other similar functions, the file is "changed". Consider setting recalculation to "Manual" as opposed to "Automatic", if that's the case.

 

[sir42]

Thanks for this! Do you know if there's a way to search for these functions in the file? I don't recall adding anything like this but it's not impossible.

Is there some automatic recalculation going on in the workbook? If there is automatic recalculation happening - for instance, use of the =TODAY() Function or other similar functions, the file is "changed". Consider setting recalculation to "Manual" as opposed to "Automatic", if that's the case.

 

[campyguy]

Use Excel's "Find" Command - not the "Search" Command. The Find Command is under the Edit Menu or invoked by the Control-Shift-F Keyboard combination. There are dozens of Excel Commands/Functions that automatically update/recalculate upon opening unless you dictate otherwise via VBA calls.

Also - this is what I do when proofing my Excel cells - use the "Show Formulas" Command in order to see all of your entered data, it's a toggled function.

And, keep in mind that you could have a formatting error - a formula that is formatted as text will not calculate unless it's formatted as "General", and vice versa in that you may have typed some text and not formatted it as "Text", therefore Excel is attempting to execute a function instead of simply displaying text…