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

You may like these other stories...

In the old days, we used to tape down receipts from our travels and submit them to accounts payable. But that was before remote employees who may live in a different city from the home office. And of course, there's all...
In 2011, electrical services and technology provider Parsons Electric in Minneapolis, Minn., decided to take its accounting to the cloud. Monica Ross, the company's director of strategic projects, talked with AWEB about...
Event Date: July 24, 2014, 2 pm ET In this presentation Excel expert David Ringstrom, CPA revisits the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both boost the...

Upcoming CPE Webinars

Jul 16
Hand off work to others with finesse and success. Kristen Rampe, CPA will share how to ensure delegated work is properly handled from start to finish in this content-rich one hour webinar.
Jul 17
This webcast will cover the preparation of the statement of cash flows and focus on accounting and disclosure policies for other important issues described below.
Jul 23
We can’t deny a great divide exists between the expectations and workplace needs of Baby Boomers and Millennials. To create thriving organizational performance, we need to shift the way in which we groom future leaders.
Jul 24
In this presentation Excel expert David Ringstrom, CPA revisits the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both boost the integrity of your spreadsheets, but reduce maintenance as well.