SOLUTION #1: Remove Google Drive's Real-Time Presence in Microsoft Office

Google Drive has an excellent feature called "Real-time Presence in Microsoft Office". It allows users of google drive to know if someone else is currently editing a document that they are working on. When this feature is off, you can not confirm that you and your associate aren't editing the same document simultaneously.

While the concept of the feature is terrific, it can dramatically slow down Excel and Chrome.

If you see this error message:  "Microsoft Excel is waiting for another application to complete an OLE action." This is definitely slowing down your computer!!!

Here are the steps to disable "Real-time Presence in Microsoft Office" from Google Drive.

  1. In the bottom right corner of my computer, click the more  ^  carrot on the taskbar and then click the rainbow Google Drive icon 

  2. Click Settings (Gear Icon) and then click Preferences.

  3. At the top right, click Setting (Another Gear Icon)

  4. Uncheck the See if someone else is editing a shared Microsoft Office file box.

  6. Click Done.

  7. Click the blue Restart Now button

  8. After you turn this feature off, remember it's vital to now be more careful about simultaneously editing documents with your colleagues. This can lead to destructive edits.





SOLUTION #2: Disable Excel's Dynamic Data Exchange (DDE)

  1. Disable Excel's Dynamic Data Exchange (DDE)
    1. Open Excel.
    2. Click on File > Options.
    3. Click on the Advanced option in the left pane.
    4. Scroll down in the right pane to the General section.
    5. Select the Ignore other applications that use Dynamic Data Exchange (DDE) checkbox.
  2. Enable Dynamic Data Exchange Server Lookup
    1. Open Excel
    2. Click on File > Options
    3. Click on the Trust Center option in the left pane.
    4. Click Trust Center Settings... button on right hand side
    5. A new window will popup
    6. Click External Content option in left hand pane
    7. Uncheck Enable Dnyamic Data Exchange Server Lookup



SOLUTION #3: Run Routine Maintenance

  1. Run a webroot scan
    1. Find the green "w" WebRoot icon in the task tray (bottom right corner of Windows)
    2. Right-click and select Scan Now
    3. Wait 2-3 minutes for results
    4. In the table, you should see Threats detected =0. If not, report to Josh immediately
  2. Review task manager
    1. In the bottom left corner of Windows, type "Task Manager". Click on the App
    2. You will see a diagram like this
    3. The 3 main areas of interest are highlighted in yellow. If CPU, Memory, or DIsk are problematic, they will be highlighted yellow or red
    4. If you want to see how these measurements are chaning over time, click on the Performance tab and click through the different measurements in the left-hand pane.
  3. Run disk cleanup
    1. In the bottome left corner of Windows, type "Disk Cleanup." Then click on the Ap
    2. Select the "c:\" drive and click OK
    3. Select all the checkboxes you would like, including:
      1. Downloaded Program Files
      2. Temporary Internet Files
      3. Recycling Bin
      4. Temporary Files


SOLUTION #3: Replace the Power Adapter