ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copying sheets (https://www.excelbanter.com/excel-worksheet-functions/205323-copying-sheets.html)

j.ruderman[_2_]

Copying sheets
 
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?

TomPl

Copying sheets
 
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

"j.ruderman" wrote:

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?



All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com