I have <50 sets of grouped rows in a spreadsheet (3 sub-levels of grouping at most) and for some reason it takes much longer to expand collapse one particular group vs. the others.
The only thing I can tell that is different is that these rows contain 2 named ranges (both just 1 cell constants that are used throughout the rest of the workbook).
Anyone know why I'm seeing such a long delay?
(I've searched all over the place and can't seem to find an answer)
Thanks,
ModSimGuy
The only thing I can tell that is different is that these rows contain 2 named ranges (both just 1 cell constants that are used throughout the rest of the workbook).
Anyone know why I'm seeing such a long delay?
(I've searched all over the place and can't seem to find an answer)
Thanks,
ModSimGuy