This suggestion might work for at least one problem: Recalc time

If you have the following conditions:

1)Large tables of information that contain the same formulas copied down to
the bottom of the table
AND
2)The information for old data rarely, if ever, changes.

Then
Sselect all of the table formulas except the first row.
Copy/Paste Values right over the same formulas....Done.

Note: Leave the first row of formulas intact. That way, whenever you need
to recalc a row, or rows, you can just copy those formulas to where you need
them.

If you have tens of thousands of formulas, the recalc time should decrease
appreciably. (You might also decrease the file size.)

Does that help?

Regards,
Ron