Forum Discussion
ccmugwump
Jun 02, 2023Copper Contributor
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...
NikolinoDE
Jun 02, 2023Gold Contributor
To save one sheet of an Excel spreadsheet without the links to other sheets, you can follow these steps:
- Open the Excel spreadsheet that contains the multiple sheets.
- Right-click on the sheet tab of the sheet you want to save as values-only.
- Select "Move or Copy" from the context menu. This will open the Move or Copy dialog box.
- In the dialog box, select the option "Create a copy" at the bottom.
- Check the box that says "Create a copy" and choose the option "New Workbook" from the drop-down menu.
- Click "OK" to create a copy of the selected sheet in a new workbook.
- In the new workbook, go to the "File" tab and select "Save As" to save the sheet as a separate file.
- Choose a location and provide a file name for the new file.
- In the "Save as type" drop-down menu, select the file format you prefer (e.g., Excel Workbook (*.xlsx)).
- 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.
Ozan_Bilal
Jan 12, 2024Copper Contributor
- RSchutteJan 27, 2025Copper Contributor
Save a copy of the spreadsheet, then go to 'Links' (I found this by searching in the search bar) and you can see all linked files and hit 'Break Link' for each.