|
Die klassischen Dateitypen können ab Januar 2021 nicht mehr verwendet werden. Sie können Ihre klassischen Dateien übertragen oder eine PDF herunterladen. Weitere Informationen

Copying Interlinked Worksheets

Demo anfordern

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

Kommentare

1 Kommentar

Datum Stimmen
  • Liz Habel
    • Bearbeitet

    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

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.