Forum Discussion
Saving one sheet of an excel spreadsheet without the links
I have a spreadsheet with multiple sheets which all sum up to the main spreadsheet. I would like to be able to send the main spreadsheet with just the values instead of the formulas. I used the m...
After copying the sheet to a new workbook, select the entire used range.
Copy, then Paste as Values.
That will remove all formulas.
There could still be links, for example if you have data validation with a range on another worksheet of the original workbook.