How to stop Google Docs and Sheets from eating up RAM
If your computer slows down when using these applications, there are some easy ways to reduce RAM usage and improve performance.
Restart your computer
Restarting your computer can help reset your browser's state by clearing all resources used while running Google Docs and Sheets. This can free up physical memory (RAM) and other system resources used by these applications.
Turn off offline mode for Google Docs and Sheets
When you enable offline mode for Google Docs and Sheets, your browser will cache files locally for quick access without an internet connection. This can increase RAM usage, especially if you have a lot of offline documents.
That's why disabling offline mode for apps can free up some RAM since documents will now be accessed from Google Drive instead of locally.
To turn off offline mode for Google Docs, click the three-line icon in the upper right corner and select Settings. In the pop-up window, turn off Offline and click OK.
The process of turning off offline mode on Google Sheets and Slides is similar as their home pages have similar interfaces.
Optimize large documents and spreadsheets
The more complex a Google document or spreadsheet is, the more RAM it will need to process, display, and sync properly. By optimizing, you can reduce the physical memory needs of your document or spreadsheet. This can be helpful if your document or spreadsheet is large or you have a limited computer.
To optimize your Google Docs documents, try these steps:
- Remove or reduce any unnecessary or complex text formatting.
- Limit the number of media elements inserted into a document, such as images, videos, and audio files.
- Break large documents into smaller, more manageable documents.
- Resolve comments and suggestions in documents immediately to avoid overloading RAM.
To optimize your Google Sheets spreadsheet, try these steps:
- Remove any complex or unnecessary cell formatting.
- Limit complex formulas and conditional formatting.
- Split data across multiple worksheets and files to distribute the load fairly.
- Use volatile functions sparingly, as their constant updates can consume a lot of RAM.
- As with offline documentation, optimization is key.
Uninstall unnecessary add-ons
Any add-ons you have installed for Google Docs and Sheets can cause them to use more RAM than necessary. Check your installed add-ons and remove any you don't need.
- To remove an add-on, click Extensions > Add-ons > Manage Add-ons.
- Click the 3-dot icon in the top right corner of the add-on card and select Uninstall in the menu.
- Click Uninstall App in the menu that appears to remove the add-on from Google Docs and Sheets.
Clear Google Docs and Sheets cache
As you use Google Docs and Sheets, temporary files and data can build up in your browser's cache. This cached data can cause these apps to use too much RAM.
Clearing your browser cache can remove redundant data. This can reduce Google Docs and Sheets' memory usage as your browser works with fresh data.
In addition to clearing your cache, you should also try to improve your browser's overall performance so it works well with Google Docs and Sheets. For example, you can optimize Google Chrome by updating it, closing any unnecessary tabs and extensions, and turning on memory saver mode.
You should read it
- How to insert Google Sheets spreadsheets into Google Docs
- How to insert Google Sheets charts into Google Docs
- How to insert Google Sheets tables into Google Docs
- 10 tips to create beautiful Google Docs
- Useful features on Google Office applications that you don't know yet
- The way Google Docs helps you become professional
- Google Docs, Sheets and Slides update the new Material interface
- 5 reasons you should give up Excel and start using Google Sheets
- Tricks using Google Sheets should not be ignored
- Latest updates of Google Docs, Sheets & Slides that you still expect
- How to create graphs, charts in Google Sheets
- Instructions for dividing and merging columns on Google Docs
Maybe you are interested
How to fix hidden templates in Google Docs
How to Create a Budget Spreadsheet in Google Sheets
How to recover deleted Viber messages using Google Drive, iCloud
Google Labs Releases Whisk: A Tool That Allows You to Upload Images as Instructions Instead of Text Prompts
10 Google Photos Tips and Tricks You Shouldn't Miss
Google Announces Android XR, a New OS Platform for AR and VR Glasses