|
Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Remove links from a range of cells that also has cells with formulas also removes formulas?

Answered
Request Demo
When I highlight a range of cells, most of which are links but also includes a formula, the formula is also removed. Is this the expected behavior as would have have thought the formula should have stayed? 
0

Comments

1 comment

Date Votes
  • Mike Davis
    Hi John,

    Rest assured, you are not crazy. That is expected behavior, at least in classic Workbooks. This is in part due to the nature of how that product runs, but the good news is that Spreadsheets do not behave this way. You can remove a range of links and the formulas will remain.

    Feel free to try out Spreadsheets in your account if you haven't already, and if you do want to convert your existing Workbook(s) into a Spreadsheet, your CSM can assist you in transitioning those over.

    Hope that helps some. Let me know if I can clarify anything else. Thanks as always and take care!
    0

Please sign in to leave a comment.