View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jan Vente Jan Vente is offline
external usenet poster
 
Posts: 4
Default Outline.ShowLevels rowlevels:=1 is slow

Hi All,

I've created a spreadsheet with a plan-board. The plan-board is filled from
a sql server-based planning system.
The planboard has two outline levels. There are ± 300 row groups.

At the end of the code for refreshing the plan-board is this line of code:
objWS.Outline.ShowLevels rowlevels:=1
Executing this codeline takes 4 seconds. Is there a way to make this faster?

Thanks,

Jan Vente
The Netherlands