Forum Discussion
John Spencer
May 09, 2022Copper Contributor
Convert a finished spreadsheet to one that does not contain macros.
I have a fairly simple spreadsheet that calculates the sizes of hard drives and is emailed to a group of users. This works great, except that the spreadsheet cannot be seen properly in email, none of the values of the calculations are there. If opened, the users need to click 'enable editting' to see them. Can the completed workbook be 'converted'(hope that's the right word) so there are no formulas and it has the new values and cell colors, and are seen in email, and can be opened without pressing 'enable editting'?
You might save the worksheet as a PDF file and send that.
- John SpencerCopper ContributorThat's an interesting idea. Let me see what I can do with powershell and saving it as a pdf.