Opening Google Docs from Windows 10 File Explorer

Posted on

QUESTION :

I am using Google Drive Backup and Sync for Windows 10. Google Docs open VERY slowly from File Explorer. With the Chrome browser already open, it takes about 30 seconds after opening the file from File Explorer for the new tab to appear and open the Google Doc. Is there a way to improve this?

ANSWER :

Basic troubleshooting on browser:

Clear your cache and cookies.

Try an incognito or private window.

Disable browser plugins or extensions. (Chrome, Firefox, Internet Explorer, and Safari instructions.)

Reset your Chrome settings.

Run Chrome Cleanup Tool, to remove software that may cause Chrome to experience issues

Next, click on Google Drive in the system tray > Preferences > Advanced.

By default, the Proxy setting is set at “Automatically detect proxy settings.” Instead, tick “Direct connection.”

Google Docs Help Forum

https://productforums.google.com/forum/#!forum/docs

Opening the url stored in the gsheet file directly with your browser seems to allow the gsheet file to open and begin to load immediately. This answer describes how to do that. Note that there is a bug in that code and the corrected one is provided below.

 @echo OFF
    set CHROME_PATH=C:Program FilesGoogleChromeApplicationchrome.exe
    set fn=%1
    set fn=%fn:"=%
    python -c "import json;import subprocess;subprocess.run(['%CHROME_PATH%',json.load(open(r'%fn%'))['url']])"

Steps:

  1. install Python
  2. save the code to a bat file
  3. find a gsheet file
  4. right click it
  5. open with
  6. choose another app
  7. tick always use this app to open gsheet files
  8. scroll down to the bottom and choose “look for another app on this PC”
  9. select the bat file you made

One problem is that using a bat file as the default will make all gsheet files have a blank icon. To fix this, you have to convert the bat file to an exe file and set the icon, which can be done using this program. To obtain the gsheet icon, follow these steps. Note that this script and method can also be used to fix the slow load times with gdoc files, gslide files, and so on.

I noticed that the CPU usage of “Antimalware Systems Executable” was increasing dramatically when I opened a .gdoc or .gsheet file from File Explorer. Adding an exclusion to Windows Defender improved the load time.

Go to Windows Security > Virus and Threat Protection > Manage settings > Add or remove exclusions > Add an exclusion > Process

Then enter the path to the Backup and Sync executable, e.g., “C:Program FilesGoogleDrivegoogledrivesync.exe”

Leave a Reply

Your email address will not be published.