Google Desktop Search slows Excel | AccountingWEB

Google Desktop Search slows Excel

As reported recently on the Daily Dose of Excel site, Charles Williams of DecisionModels.com tried to find out what was causing the delays on certain versions of Excel when he tried to clear a large range of cells.

Following further discussions on VBA news groups, it was found that problem could be linked to the EnableEvents property. But then, Williams discovered, "The problem actually turns out to be the Google Desktop Office Com Add-In. When you deactivate this you get a miraculous speedup."

He thought that the Google Add-In sets up one or more application-level events to monitor actions such as selection changes and worksheet changes in order to trap and index the changes. A free Decision Models benchmark timer can be used to test Excel performance with and without EnableEvents activated.

It has to be noted that Williams and his fellow VBA programmers are used to handling very large files. If your worksheet has less than 10,000 active cells, the delays will not be very noticeable. But if you do want to improve performance, the Google Desktop Add-In can be deactivated, in Excel 2007 by going to the Office Button and selecting Excel Options-Addins-Com Addins, where the Google Desktop Office Add-In can be deselected.

In earlier versions of Excel, you will have to customize a toolbar and add the Com Addins dialogue to do this, Williams advised. Go to View-Toolbars-Customize-Commands tab-Tools, and the Com Add-Ins will be visible halfway down the list. Select it and drag it to the toolbar of your choice. You will then be able to uncheck the Google Add-in.

One mystery that Williams has not yet resolved is whether this is an unintentional glitch, or a new twist in the Google-Microsoft wars.

Reprinted from our sister site, AccountingWEB.co.uk

Wait, there's more!
There's always more at AccountingWEB. We're an active community of financial professionals and journalists who strive to bring you valuable content every day. If you'd like, let us know your interests and we'll send you a few articles every week either in taxation, practice excellence, or just our most popular stories from that week. It's free to sign up and to be a part of our community.
Premium content is currently locked

Editor's Choice

WHAT KIND OF FIRM ARE YOU?
As part of our continued effort to provide valuable resources and insight to our subscribers, we're conducting this brief survey to learn more about your personal experiences in the accounting profession. We will be giving away five $50 Amazon gift cards, and a $250 Amazon gift card to one lucky participant.
This is strictly for internal use and data will not be sold
or shared with any third parties.