Google Desktop Search slows Excel

As reported recently on the Daily Dose of Excel site, Charles Williams of 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,

You may like these other stories...

We're all about QuickBooks this morning. First, read this late-breaking news from John Stokdyk, editor of AccountingWEB (U.K.), who is attending the QuickBooks Connect conference in San Jose, California. Then, for more...
Technology—specifically internet technology—has a record of disrupting tried-and-true methods of operation in ways that we often don't foresee. Look no further than the recent HBO announcement that they *gasp...
If you're thinking that bitcoin and digital currency generally are merely some one-off flash in the pan, the new Digital Currency Council would argue otherwise. The council launched in September and already had 400...

Already a member? log in here.

Upcoming CPE Webinars

Oct 23Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.
Oct 30Many Excel users have a love-hate relationship with workbook links.
Nov 5Join CPA thought leader and peer reviewer Rob Cameron and learn ways to improve the outcome of your peer reviews while maximizing the value of your engagement workflow.
Nov 12This webcast presents basic principles of revenue recognition, including new ASU 2014-09 for the contract method. Also, CPAs in industries who want a refresher on revenue accounting standards will benefit.