Replace formulas with their values
To send a table without its calculations or its links to other files, or so that it stops moving: each formula becomes the value it displayed. It is Excel's Paste Special, Values, on all the chosen sheets at once.
What this tool does
- The number of formulas on each sheet, and the choice of sheets to freeze.
- Each formula replaced by its last calculated value; numbers, text, dates and booleans keep their type.
- Formatting, column widths and the other sheets stay as they are.
- The output file is read back: every value is the same as before.
What it does not do: The value kept is the one Excel saved at the last calculation: if the workbook was saved without recalculating, that is the value. A formula with no saved value becomes an empty cell, and it is counted.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Slim down a workbook : Phantom rows, thousands of styles, copied formatting: the extra weight, removed.
- Remove external links : The "this workbook contains links" warning goes away: formulas become values.
- Unmerge cells : Merges removed and the value copied everywhere: you can finally sort and filter.
- Recover a damaged file : The repaired workbook when possible, and always the data that could be read.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.