|
Os tipos de arquivos clássicos não estarão mais disponíveis para uso a partir de janeiro de 2021. Você pode fazer a transição de seus arquivos clássicos ou baixar um PDF. Saber mais

Copying Interlinked Worksheets

Solicitar demonstração

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

Comentários

1 comentário

Data Votos
  • Liz Habel
    • Editado

    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

Por favor, entrar para comentar.