|
Klassiske filtyper er ikke lenger tilgjengelige for bruk fra og med januar 2021. Du kan overføre klassiske filer eller laste ned en PDF-fil. Finn ut mer

Break links in excel after exporting file

Be om demo

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

Kommentarer

3 kommentarer

Dato Stemmer
  • 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

Logg på for å legge inn en kommentar.