Copying sheets

J

j.ruderman

I'm tring to copy a sheet to a new workbook. The formulas are all linking
back to the original workbook. This only seems to happen with this one sheet.
Is there a setting a may have checked off?
 
T

TomPl

I don't think it is anything you checked. I think that any references to
other worksheets will refer back to the original workbook. You can convert
all of those links to values with <Edit><Links><BreakLinks>.

Hope that helps.

Tom
 

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

Top