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 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.
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.
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.
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.
