Convert a finished spreadsheet to one that does not contain macros.

%3CLINGO-SUB%20id%3D%22lingo-sub-3343369%22%20slang%3D%22en-US%22%3EConvert%20a%20finished%20spreadsheet%20to%20one%20that%20does%20not%20contain%20macros.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3343369%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20fairly%20simple%20spreadsheet%20that%20calculates%20the%20sizes%20of%20hard%20drives%20and%20is%20emailed%20to%20a%20group%20of%20users.%20This%20works%20great%2C%20except%20that%20the%20spreadsheet%20cannot%20be%20seen%20properly%20in%20email%2C%20none%20of%20the%20values%20of%20the%20calculations%20are%20there.%20If%20opened%2C%20the%20users%20need%20to%20click%20'enable%20editting'%20to%20see%20them.%20Can%20the%20completed%20workbook%20be%20'converted'(hope%20that's%20the%20right%20word)%20so%20there%20are%20no%20formulas%20and%20it%20has%20the%20new%20values%20and%20cell%20colors%2C%20and%20are%20seen%20in%20email%2C%20and%20can%20be%20opened%20without%20pressing%20'enable%20editting'%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3343369%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3344851%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20a%20finished%20spreadsheet%20to%20one%20that%20does%20not%20contain%20macros.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3344851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F205559%22%20target%3D%22_blank%22%3E%40John%20Spencer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20might%20save%20the%20worksheet%20as%20a%20PDF%20file%20and%20send%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3357700%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20a%20finished%20spreadsheet%20to%20one%20that%20does%20not%20contain%20macros.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3357700%22%20slang%3D%22en-US%22%3EThat's%20an%20interesting%20idea.%20Let%20me%20see%20what%20I%20can%20do%20with%20powershell%20and%20saving%20it%20as%20a%20pdf.%3C%2FLINGO-BODY%3E
New Contributor

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'?  

2 Replies

@John Spencer 

You might save the worksheet as a PDF file and send that.

That's an interesting idea. Let me see what I can do with powershell and saving it as a pdf.