|
Les types de fichiers classiques ne pourront plus être utilisés à partir de janvier 2021. Vous pouvez transférer vos fichiers classiques ou télécharger un PDF. En savoir plus

Copying Interlinked Worksheets

Demande de démonstration

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

Commentaires

1 commentaire

Date Votes
  • Liz Habel
    • Modifié

    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

Vous devez vous connecter pour laisser un commentaire.