Spreadsheet Freezer Help

Overview

When Spreadsheet Freezer is enabled for a spreadsheet, it creates an empty formula store for that spreadsheet. On user demand, the user selected formulas are added to/removed from the formula store and the ranges that originally hold those formulas are frozen/unfrozen.

By freeze we mean that the formulas are overwrote by their results.

By unfreeze we mean that the formulas results are cleared and the formulas are added again to their original cells.

Why

• At this time, in contrast as other spreadsheet app do, Google Sheets doesn't include a setting to stop the spreadsheet recalculation.
• It's common that users use calculation expensive formulas that later could be hard to find and fix or substitute for non expensive formulas

How-to

Spreadsheet Freezer functions are available through the Google Sheets Add-ons menu.

Freeze my spreadsheet

To Freeze click Add-ons > Spreadsheet Freezer > Freeze.

Unfreeze my spreadsheet

To Unfreeze click Add-ons > Spreadsheet Freezer > Unfreeze.

Remarks

• The formulas saved on the document properties created by Spreadsheet Freezer are only accesible by the add-on when it's being used on the corresponding spreadsheet.
• Spreadsheet editors could add, remove, list the formulas, freeze, unfreeze, enable / disable the add-on.

Tips

• Before uninstalling Spreadsheet Freezer unfreeze your spreadsheets.
• Always make a copy of your spreadsheet before making major changes.
• If you handle large data sets and / or open references like A:A or 1:1 keep an eye on the number of cells of your spreadsheet

Questions

If you have questions about how to use Spreadsheet Freezer, please post them on Web Applications by using the following tags:

• google-sheets
• google-sheets-addons
• spreadsheet-freezer

If you have inquiries that aren't about how to use Spreadsheet Freezer like a feature request please send it through Feedback.

Concerns

• Most people don't like to read help stuff like this. If you read so far, please let us know through Feedback.