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
