Forum Discussion
Need to Export VALUES instead of the FORMULA... is this possible?
I have a large amount of information on Tab 1 in my Excel spreadsheet. Every month I must generate a monthly report based on a subset of this data and email to someone, so I have prepared the repo...
DMGonzalez Once you have created your new workbook, select all cells. Copy them and paste all in in the same place as values. You'll find that option under "Paste special". This preserves all your original formats and lay-out, but all formulae will now be values.
Alternatively, print your original report (with formulae) to PDF and send the PDF file in stead.