I have a worksheet which contains 6,000 rows with subtotal amounts. When I
hit = to begin the calculation all hidden cells expand, which I don't want to
occur as locate the subtotalled cells is difficult.

How do I stop the hidden cells from becoming visible when trying to perform
the calculation?