Page 1 of 1
excel not responding - action button
Posted: Wed May 02, 2012 7:35 am
by 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
Re: excel not responding - action button
Posted: Wed May 02, 2012 7:52 am
by yuval
the calculate via action button is becoming slower when other excel files are open
Re: excel not responding - action button
Posted: Wed May 02, 2012 10:10 am
by 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
Re: excel not responding - action button
Posted: Wed May 02, 2012 11:24 am
by yuval
I have to run process after the calculation but it's a nice solution,
thanks