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...

Cybersecurity is no longer the domain of an organization's IT staff. It's moved to the boardroom, and in a big way. Accountants and financial managers may have been thinking it's just the province of the tech...
You probably don't want to think about how many times you access the File menu in Excel 2010 or 2013. Personally I think Excel 2010 has the best possible File menu arrangement, other than having Print Preview grafted...
Following other recent high-profile hacking events, investigators discovered yesterday that hackers broke into the draft work paper files of several famous CPA firms. Revealing images of the scantily clad documents have been...

Already a member? log in here.

Upcoming CPE Webinars

Sep 24
In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards. A dashboard condenses large amounts of data into a compact space, yet enables the end user to easily drill down into details when warranted.
Sep 30
This webcast will include discussions of important issues in SSARS No. 19 and the current status of proposed changes by the Accounting and Review Services Committee in these statements.
Oct 21
Kristen Rampe will share how to speak and write more effectively by understanding your own and your audience's communication style.
Oct 23
Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.