Forum Discussion
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.
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.
alright, you may be right, maybe this feature is not so needed. but it did trouble me many times.. thank you