|
Klassiska filtyper är inte längre tillgängliga för användning från och med januari 2021. Du kan överföra dina klassiska filer eller ladda ner en PDF. Läs mer

Copying Interlinked Worksheets

Begär demo

My workbook contains a pair of worksheets, SheetA and SheetB.

SheetA contains formulae that link to SheetB.

I would like to duplicate both Sheet A & B  to create Sheets C and D), and I would like the formulae to point at the new worksheets (Sheet C linking to Sheet D).

Is it possible to do this?
When I try the standard 'select worksheets, right click, duplicate' option, the links in the new worksheet, SheetC, all point to the original source worksheet, SheetB. 

1

Kommentarer

1 kommentar

Datum Röster
  • Liz Habel
    • Redigerad

    Hi Peter,

    Thanks for reaching out! Unfortunately, there isn't an automated way to accomplish this. The only option is to duplicate both sheets and then update the formulas. 

    I've created a feature request with our product team for this, and we will keep you updated as it moves forward. 

    0

Du måste logga in om du vill lämna en kommentar.