Quick Tools - Formula ToolsEstimated reading time: 1 minute
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:
Note the cell C3 refers to a cell in the external file "D:\Users\jimd\Documents\Sales\Projections.xlsx".