Break links in excel after exporting file
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.
-
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
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
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댓글을 남기려면 로그인하세요.
댓글
댓글 3개