slow .Clear in 2007 - microsoft.public.excel.programming

Message from discussion slow .Clear in 2007

brzak

View profile

More options Dec 7 2007, 4:38 am

Newsgroups: microsoft.public.excel.programming

From: brzak <brz...@gmail.com>

Date: Fri, 7 Dec 2007 01:38:05 -0800 (PST)

Local: Fri, Dec 7 2007 4:38 am

Subject: Re: slow .Clear in 2007

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

Initially, it was tricky to work out how to uninstall an Add-In.

I did it by going to Excel Options, selecting the Add-Ins tab, then
from the "Manage:" drop down list select COM Add-Ins and click Go, and
just deselect the GD Add-In.

From what I recall, this would have been a lost easier if there was a
clearer relationship between the drop down list and the display above.

Luckily it is a separate Add-In for Outlook, i'm not sure what the
excel add-in was for but the outlook add-in makes searching email a
lot easier. It's funny, it *seems* like such a simple thing but the
built in search for Outlook just cannot be compared to GD search.

On Dec 5, 6:47 pm, "Charles Williams" <Char...@DecisionModels.com>
wrote:

> Thanks for the tip about Google Desktop.
> I tested it and agree it seems to be the cause of the problem. If you
> uninstall it the problem goes away.

> Actually you can just get rid of the Google Office Com Addin:
> Customise a toolbar, select Tools and add the Com Addins button to the tool
> bar by dragging it to the toolbar.
> Then select Google Office Search and uncheck it.

> I guess what its doing is setting up and running a workbook level event on
> sheet change that can chew up a LOT of cpu cycles.
> Using .EnableEvents=false prevents this from happening, but its better to
> just get rid of it.

> regards
> Charles
> _________________________________________
> FastExcel 2.3
> Name Manager 4.0http://www.DecisionModels.com

Reply to author Forward