Why does SaveAs trigger a recalculation that a simple Save does not?

Question

-Workbook has "Recalculate before Save" turned on.

-No changes made to file

-using "Save" on file does not trigger a noticeable recalc

-using "SaveAs" DOES trigger an extensive recalc (and unexpectedly triggers other code)

It isnt the recalc that bother me as much as why is the behavior so radically different?

Answer 1

Using SaveAs ALWAYS do CALCULATION even you did SAVE prior SaveAs.

Answer 2

"...Even you don’t change the file name when you use SAVE AS, it will always RECALCULATION..."

No. No. No.

"Always" is quite incorrect, and is the source of my question.

The behaviour I describe ONLY happens if "Recalc before Save" is on AND I use SaveAs. No other combination will produce this behavior. No matter how I invoke a calculation, I have Change Event code (attached to linked Forms controls on one sheet) that unexpectedly running ONLY when using SaveAs AND "Recalc Before Save" together.  No other manner of invoke a calculation will cause this code to run. So, it seems to me, SaveAs is behaving unpredictably.

I already have workarounds in place so my workbook remains usable but in trying to determine how/why SaveAs does what it does, I am trying to anticipate any other SPECIFIC known gotchas my users might run into when using SaveAs.

Answer 3

Even you don’t change the file name when you use SAVE AS, it will always RECALCULATION, take note, all formula in your template, and it is the nature of excel, there’s no settings we can avoid it, hope there’s in the future version of Excel.  When using SAVE or hitting F9 (calculate) only the changes you made will do the calculation.

Just have patience,

~jaeson

Answer 4

Recalc before save is on

1. Recalc
2. immediately Save
3. immediately SaveAs (filename changed slighly in dialog box)

step 3, and ONLY step 3 causes a very extensive Recalc that triggers various code attached to Change events to run which is NOT happening during 1 or 2. Why isnt this code triggered during 1 or 2 (the preference)? Why does SaveAs behave so differently?

the wayward code does NOT run durinf step 3 when Recalc before save is off.

Answer 5

It is the nature of excel to re-calculate if you do Save-As since version 2000 as far as I remember. If you only use Save and not calculate, might it calculate before you do Save only. Re-Calculation for Save-As sometimes losses your precious time, my tip is just SAVE it then copy the file into the location you want, then MAGIC, it will not calculate.

Hope my advice add precious time in your work,

~jaeson