It is not a built-in feature.
However, if you run this code, it should do the job.
Dim strPath As String
Dim ws As Worksheet
Application.ScreenUpdating = False
strPath = ActiveWorkbook.Path & "\"
For Each ws In ThisWorkbook.Sheets
'Use this line if you want to break any links:
Workbooks(Workbooks.Count).Close True, strPath & ws.Name & ".xlsx"
Application.ScreenUpdating = True
Sub BreakLinks(wb As Workbook)
Dim lnk As Variant
For Each lnk In wb.LinkSources(xlExcelLinks)
wb.BreakLink lnk, xlLinkTypeExcelLinks
To run the code, do the following:
- Open the VBA editor (Alt-F11)
- In the tree in the top left corner, right click on your workbook and insert a new module
- Copy the above code into this module
- Close the VBA editor
- In Excel press Alt-F8 to run macros and select