Forum Discussion

Sea Flying's avatar
Sea Flying
Copper Contributor
Jan 13, 2017

Why Excel dosen't provide Formula only save its value to file, not munually, but a option for auto

We often save plenty of Formula's results via Ctrl+C -- paste only value or VBA macro, it's unconvenient sometimes.

Formulas & Functions
Show and Tell

4 Replies

  • Nolan Tripp's avatar
    Nolan Tripp
    Copper Contributor
    Jan 16, 2017

    If you do not need any of the formatting you could save as a CSV file type. If you need to preserve the formatting and don't want others to change the values you can save as a PDF file type.

     

    It seems like it would be easy to record a macro that selects the entire worksheet, then paste>special>values. We could then add it to the QAT and then press the Alt key and choose the number assigned to run the macro.

     

    If MS did add the capability you describe I would want many warnings before the save so the formulas wouldn't be converted on accident.

    • Sea Flying's avatar
      Sea Flying
      Copper Contributor
      Jan 18, 2017
      alright, you may be right, maybe this feature is not so needed. but it did trouble me many times.. thank you
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Jan 13, 2017

    Actually, there is no prepared tool to remove a formula and keep its value.

    I think that Microsoft Excel team didn't see the need for such a tool.

    Because there is some easy and sufficient ways to get the result form a formula.

     

    For more information, just watch this video:

    https://www.youtube.com/watch?v=HCsO_m6J2TA

     

    With regards.

Resources