Copy sheet from one workbook to a new workbook without having them linked

  • Thread starter Thread starter Gilbert Aponte
  • Start date Start date
G

Gilbert Aponte

I have 2 workbooks. Workbook one has 10 different sheets
of information and formulas. Workbook two has 4 different
worksheets.

I need to copy an entire sheet from workbook 1 to workbook
2. However, when I copy from one to the other, it
autolinks all the data and formulas back to the
originating workbook. I need all the formulas, formats,
text etc. but don't want them to be linked to each
other. I have tried to special paste but have had no
success.

Need help with this task.
 
Gilbert,

It sounds as if your source sheet already has some links to some other
sheet. Look through the cells for formulas that refer to other sheets or
even to other workbooks:

='Sheet 2'!$B$2
=[Book2]Sheet1!$A$1
 
Back
Top