Microsoft Office Tutorials and References
In Depth Information
Using the New Binary File Format: BIFF12
formats that are macro free and file formats that are macro enabled. Here
are the two XML file formats that Excel 2013 supports:
XLSX — Files stored with the .xlsx extension are the default file
type in Excel 2013. This XML file format does not allow macros.
XLSM — Files stored with the .xlsm extension are XML files that al-
low for the inclusion of VBA macros.
The new XLSX and XLSM file formats are actually Zip files, which makes it
easy to look inside the file formats. Figure 7.5 shows a worksheet that has a
number of elements. It has a pivot table in row 20, WordArt, SmartArt, spark-
lines, slicers, and a chart.
Figure 7.5. This workbook is saved in XLSM, one of the new XML formats.
This workbook is saved in XLSM, one of the new XML formats.
To look inside any Excel 2013 document, follow these steps: