Re: List manager slowdown

Tech-Archive recommends: Fix windows errors by optimizing your registry

On 11/14/06 5:07 PM, in article askme-792C60.14070214112006@xxxxxxxxxxxxxxx,
"Posterizer" <askme@xxxxxxxxxxxxxxx> wrote:

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
I don't use list manager, but that's not a very large list to me. I've used
(again not with list manager) lists of 10,000+ rows x 150 columns without
much delay. Do you have plenty of hard disk space? Have you run disk tools
lately or diskwarrior?

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

.

Relevant Pages

  • Re: the row has disappeared and its not hiding
    ... How do you know it's not hidden or maybe it is shrunk so it can't be seen? ... total row on the lists menu, ...
    (microsoft.public.excel.misc)
  • Re: how do i activate the list command in data menu
    ... Excel 2002. ... Use Data>Filter>AutoFilter to create the dropdown lists at ... in the list's Total row. ... > not have the list command in the data menu Excel XP. ...
    (microsoft.public.excel.misc)
  • Re: Printing Excel Lists in Word
    ... however - other than turning the AF Off while you copy - the only ... When I copy a List from Excel and Paste Special/ Paste Link/ Microsoft Excel ... Sheet Object into Word the resulting graphic includes the list visuals. ... every single List I want to do this with (I copy and paste Lists a ton). ...
    (microsoft.public.mac.office.word)
  • Re: Printing Excel Lists in Word
    ... On another sheet in the book create a formula link to the list, ... buttons which are separate from Visuals. ... When I copy a List from Excel and Paste Special/ Paste Link/ Microsoft Excel ... every single List I want to do this with (I copy and paste Lists a ton). ...
    (microsoft.public.mac.office.word)
  • Re: Printing Excel Lists in Word
    ... On another sheet in the book create a formula link to the list, ... buttons which are separate from Visuals. ... option I know of is to Paste Special as Formatted Text (RTF). ... every single List I want to do this with (I copy and paste Lists a ton). ...
    (microsoft.public.mac.office.word)