Convert GPT formulas to static values and prevent any further recalculation, either on a selected number of cells or across an entire sheet. If you need to recover the original formulas later, you can use the version history of your Microsoft workbook.
- You have opened a workbook containing GPT formulas.
- You have opened the GPT for Excel add-in from the Home tab.
Replace formulas manually
Select the cells that contain the GPT formulas.
Copy them by pressing Ctrl+C (or Cmd+C on Mac).
Note: For GPT formulas with multi-row results, copy all rows with results, not just the formula row.
Paste the results as values by pressing Ctrl+Shift+V (or Cmd+Shift+V on Mac).
GPT formulas within the manually selected cells are replaced by their respective results.
Replace formulas in selection
Select cells that contain GPT formulas in the current sheet.Warning
Always select the full range of results for formulas like GPT_LIST to prevent data loss.
Choose In selection in the Replace formulas dropdown.
GPT formulas within the selected cells are replaced by their respective results.
Replace formulas in entire sheet
Choose In sheet in the Replace formulas dropdown.
All GPT formulas within the sheet are replaced by their corresponding results.