List manager slowdown
- From: Posterizer <askme@xxxxxxxxxxxxxxx>
- Date: Tue, 14 Nov 2006 14:07:02 -0800
Gang, I have a fairly large list in Excel 11.3. I'm using List Manager,
including the autofilters, total row and visuals. I'm currently up to
row 1829 (the total row) and use columns A through X, with 7 columns
being "calculated columns" containing formulas. I have a modest amount
of color filling in some cells and a sprinkling of comments throughout.
So I've got quite a bit going on with this list.
It's slowed down considerably lately, most noticeably when filtering. I
get a wristwatch followed by the spinning beachball. Not eternal waits,
but maybe 5-10 seconds, when it used to filter almost immediately.
Excel has also been crashing a LOT lately. I haven't noted whether it
only crashes when I have this doc open, or if it's done it with other
docs. I do know that it's particularly unstable if I have Classic
running in the background, but it has crashed without it, too.
I could swear that I once read in the Excel help that once a list got to
a particular size that it was a good idea to do something to improve
performance...I thought it was turning off the visuals, but that made no
difference. Now I can't find the statement in the help files that I
thought I read before.
I'm running this on a 1.6 GHz Powermac G5 tower with 1.25 GB memory, OS
10.4.8.
Any suggestions?
thanks :)
_dennis
.
- Follow-Ups:
- Re: List manager slowdown
- From: Geoff Lilley
- Re: List manager slowdown
- From: Bob Greenblatt
- Re: List manager slowdown
- Prev by Date: Re: xlsx files
- Next by Date: Re: How do I pass an array as an argument to a VBA Function
- Previous by thread: xlsx files
- Next by thread: Re: List manager slowdown
- Index(es):
Relevant Pages
|
