excel not responding - action button

[yuval]

Im trying to run a process via action button, in calculate tab (action button) I choose "automatically recalculate sheet", it seems that
it trying to calculate the all workbook and it takes long time, does someone know this issue?
thanks,
Yuval

[yuval]

the calculate via action button is becoming slower when other excel files are open

[Steve Rowe]

It sounds like the calculate option is calculating the whole xl space and not just a single sheet.
If the only thing your action button is doing is calcualting the sheet then this is v easy to do yourself.

Make sure you have the tm1.xla loaded
Start recording a macro
press shift+f9
Stop Recording

Assign the macro you just created to your own button / drawing button / short cut.

(or just put a piece of text at the top of your table to say press shift+f9 to calculate)!

Cheers

[yuval]

I have to run process after the calculation but it's a nice solution,
thanks