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

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

Earl Kiosterud

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
VBA Copy values only onto new workbook 1
Copy formula from one workbook to another without reference to 1st 4
Copy sheet to different workbook 1
problems getting this macro to work 23
Excel Move or Copy Stopped Working? 0
Paste Values in linked Cells Only 4
Macro to Copy Sheets to new workbook 18

Top