A
Alex J
All,
I am trying to programatically apply an Outline to a sheet of about 1000
data rows.
So I use: Sheets("Sheet1").Rows(i).OutlineLevel = x
in a loop and this works fine on a test sheet. It takes about 0.3 seconds
for 1000 lines.
Problem:
With a large file loaded in Excel (about 8Meg - not THAT large), but not
active, the same test routine on the same test sheet in the same test file
slows to about 1.5 seconds PER LOOP STATEMENT !
Have tried all performance tricks I know - events, calculation,
screenupdating, disabling macros of the big spreadsheet, clearing the TEMP
directory. It appears that memory availability highly impacts performance of
the outline function.
Has this been encountered? Any workarounds, or am I somehow mis-applying the
OutlineLevel approach?
This seems to happen in XL2000 and XL2002.
Thanks for any enlightenment,
Alex J
I am trying to programatically apply an Outline to a sheet of about 1000
data rows.
So I use: Sheets("Sheet1").Rows(i).OutlineLevel = x
in a loop and this works fine on a test sheet. It takes about 0.3 seconds
for 1000 lines.
Problem:
With a large file loaded in Excel (about 8Meg - not THAT large), but not
active, the same test routine on the same test sheet in the same test file
slows to about 1.5 seconds PER LOOP STATEMENT !
Have tried all performance tricks I know - events, calculation,
screenupdating, disabling macros of the big spreadsheet, clearing the TEMP
directory. It appears that memory availability highly impacts performance of
the outline function.
Has this been encountered? Any workarounds, or am I somehow mis-applying the
OutlineLevel approach?
This seems to happen in XL2000 and XL2002.
Thanks for any enlightenment,
Alex J