Recalculate:
Force recalculate - F9 by default, but could be reassigned. OR on the menu
at Data --> Calculate --> Recalculate
There's also "recalculate hard" which is (probably misunderstood by me)
like the first calculate on load. CTRL-F9 or the same menu as recalculate.
___
Macros:
I am having trouble following what is happening (and I guess I missed the first
reply.
First, it looks like the cell D2 is calling a macro.
If I understand, the cells are NOT recalculating so you are causing each one to
run manually. What happens if you use
Data > Calculate > Recalculate
On 3/1/23 09:13, Michael Tiernan wrote:
On 12/23/22 11:02 AM, Andrew Pitonyak wrote:
If you are looking to cause functions to recalculate,
Thanks for the reply.
Here's the thing. It's not that I want to force a recalculate, it's
that I have to in order to get the macros to respond.
Here's
On 12/23/22 11:02 AM, Andrew Pitonyak wrote:
If you are looking to cause functions to recalculate,
Thanks for the reply.
Here's the thing. It's not that I want to force a recalculate, it's that
I have to in order to get the macros to respond.
Here's an example: (What I expect when the
