If you need to share an Excel workbook with someone who doesn’t have iplicit functions or add‑ins enabled, you can convert all formulas to values so the file opens without errors.

  1. Save the workbook under a new name (recommended)
  2. Press Ctrl+A to select the whole sheet (or highlight only the ranges you want)
  3. Press Ctrl+C to copy
  4. Right‑click and choose Paste Special → Values
    (or use the shortcut Ctrl+Alt+V → V → Enter)

This replaces all formulas with static values, allowing users who don’t have Excel add‑ins or implicit functions enabled to view the figures without errors.


Customer search terms

Excel functions

Convert formulas to values

Paste special values

Remove iplicit function errors

Non iplicit user for excel worksheet

_______________________________________________________________________________________