showlevels is very slow

[kurt]

Hi

I have done a large spreadsheet with 3 levels.

When I chose one level the spreadsheet (on the litle square top left)
the spreadsheet works very slow, proberly because it recalculate all
the time.

Is there a trigger where I can stop the recalculation after I have
choosed eg. level3 to run a macro to stop the recalc start it
afterwards.

regards

Kurt

 

[Dave Peterson]

You can change calculation mode via
tools|Options|calculation tab
(xl2003 wording)

Then show what you want

Then toggle the calculation back to automatic

If you need a macro, try recording one when you do it manually.

 

[kurt]

Hi all

Thank you Dave for your answer, Yes I anm familiar with this method.

But how do you do it from a macro, I need a trigger so when i pres the
square top left then
stops the recalc
does the showlevel function
start the recalc

thanks in advence

regards
Kurt

 

[Dave Peterson]

I don't think you can.

But you could do the whole thing in code. Don't click on the outlining
symbols. Use your macro (macros???) instead.