|
Los tipos de archivo clásicos dejarán de estar disponibles a partir de enero de 2021. Puedes migrar tus archivos clásicos o descargar un PDF. Más información

Break links in excel after exporting file

Solicitar demostración

Would it be possible to consider breaking links and leaving only values (where an error is given in the formula) in the exported file if I select an option to download the file with accurate formulas? 

I one of our case we have to export excel calculations that has multiple formulas referring to multiple sheets, but for a particular report we need to export only few sheets that are linked with formulas between each other, however we still have other data that is linked with different sheets and once extracting such excel we still have errors since part of file is missing its reference.

1

Comentarios

3 comentarios

Fecha Votos
  • Brooke Mortvedt

    Great feedback! Thanks, Lukas Rakickas - I have documented this for a team to review and see if this can be implemented. 

    Anyone passing by that would find value in this, please comment to get added to the ticket! 

    Have a great day 😊

    0
  • Kelson Moran

    I second this request. We have spreadsheets that we only need to export certain tabs for external purposes. Currently I have to export the whole thing, then either hide excessive tabs, or go through the motions to move the unneeded tabs to a different workbook and then break the links, which then hard codes the values that were linked but doesn't break the other formulas that are still functional.

    0
  • Brooke Mortvedt

    Thanks for your additional details, Kelson Moran. I have added you to this request & will pass on your need for this feature. I hope you have a great day! 

    0

Iniciar sesión para dejar un comentario.