Quick Tools - Formula Tools

Estimated reading time: 1 minute

Overview

The Formula Tools within Quick Tools deal with formulas.


Remove External References

Removes all references in the Workbook to external files/objects and converts the formula in the cells to a text/numeric value.

Note: When there are references in the Workbook to external files, the "Edit Links" button will be visible on the Data tab:


Before:

Note the cell C3 refers to a cell in the external file "D:\Users\jimd\Documents\Sales\Projections.xlsx".


After: