Saving one sheet of an excel spreadsheet without the links

[ccmugwump]

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 move/copy function to move it to its own file but when you open the file it complains about the rest of the sheets not being there.  

[#2]

@ccmugwump 

To save one sheet of an Excel spreadsheet without the links to other sheets, you can follow these steps:

1. Open the Excel spreadsheet that contains the multiple sheets.
2. Right-click on the sheet tab of the sheet you want to save as values-only.
3. Select "Move or Copy" from the context menu. This will open the Move or Copy dialog box.
4. In the dialog box, select the option "Create a copy" at the bottom.
5. Check the box that says "Create a copy" and choose the option "New Workbook" from the drop-down menu.
6. Click "OK" to create a copy of the selected sheet in a new workbook.
7. In the new workbook, go to the "File" tab and select "Save As" to save the sheet as a separate file.
8. Choose a location and provide a file name for the new file.
9. In the "Save as type" drop-down menu, select the file format you prefer (e.g., Excel Workbook (*.xlsx)).
10. Click "Save" to save the sheet as a values-only file.

By following these steps, you will save the selected sheet as a separate file without the links to other sheets. The new file will only contain the values and not the formulas or references to other sheets.

[#3]

@NikolinoDE 

Nope this doesnt work.

[#4]

@ccmugwump 

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.