Excel: Save Spreadsheet without Macros
Question by Guest | 2015-08-27 at 10:45
When creating Excel spreadsheets, I am often using small macros in order to automate some functions.
However, this is always a problem when I would like to pass the Excel files. By default, Excel is showing some kind of security warning when trying to open such a document, so that I get many questions rather my document is okay.
So, is there any simple possibility to export the spreadsheet out of Excel without any macros?
Related Topics
XLS and XLSX: Maximum Number of Columns and Rows
Info | 2 Comments
MIME Types of Microsoft Office File Formats
Info | 0 Comments
Windows Batch Script: Computer Shutdown
Tutorial | 2 Comments
Excel: How to enter Line Break within Cell
Question | 1 Answer
Excel Error when opening CSV File: File was detected as SYLK File!
Question | 1 Answer
PHPExcel: Leading Zeros
Question | 1 Answer
PHP: Create Excel-File (XLS or XLSX)
Question | 1 Answer
Important Note
Please note: The contributions published on askingbox.com are contributions of users and should not substitute professional advice. They are not verified by independents and do not necessarily reflect the opinion of askingbox.com. Learn more.
Participate
Ask your own question or write your own article on askingbox.com. That’s how it’s done.
Since Excel 2007, Microsoft has introduced two different Excel formats. The Excel format with macros has the file extension XLSM and the file format without macros has the extension XLSX. So, in order to remove all macros from an Excel spreadsheet, it is sufficient to just pick on "Save as" and to select XLSX (Excel Workbook) as format.
Unfortunately, in older Excel versions, you do not have those specific formats. Given this case, the best way is to just create a new Excel documents and to copy only the data from the other table therein.
Or, if you have a new version of Excel for disposal, you can also open the old XLS file in the software in order to save it as XLSX (of course, after that you can save the XLSX as XLS again to get rid of the macros).
2015-08-27 at 22:29