Hello,

I have a big workbook with formulas on some worksheets that refer to other worksheets.

Now I want to export (or copy) one single worksheet, to a new workbook using a VB macro. But I need to break the links in the new workbook, as I don't want its data to get updated when I change something in the "mother" work book.

I used the Worksheet.Copy method. In the code below, "Report" is the sheet I want to export (or copy):

Sub Export()
Worksheets("Report").Copy
End Sub

My problem is that the new workbook keeps links to the mother workbook. It even keeps the macro. This is not what I want, as the exported single sheet is simply a report.

Could you please help?

Many thanks in advance.