Which format is an excel macro enabled workbook saved as

Starting with Excel 2007 Microsoft introduced a series of new file formats to replace the .xls. Each of these new formats has different functionality and uses. It is important to b

Which format is an excel macro enabled workbook saved as
whitepaper-pic-big

Starting with Excel 2007 Microsoft introduced a series of new file formats to replace the .xls. Each of these new formats has different functionality and uses. It is important to be familiar with the different formats, particularly if you regularly work with large documents. This technical update details the file extensions available in Excel and when AMT recommends that these should be used. You can see the difference between two of the most commonly used file formats by downloading the files below and observing how long they take to open.

These files do not contain real data. Please feel free to duplicate the data to increase the file size and see how it affects the file types load time.

  • Mock data XLSX
  • Mock data XLSB

What is an Excel file extension?

Excel File extension

Excel File format

Description

When to use this excel extenison

.xlsx

Excel workbook

This is the main replacement for the former binary .xls format. For enhanced security, this format does not support Excel macros. Underlying this format is a ZIP archive of XML documents.

The default Excel format if macros are not used in your model.

.xlsm

Excel macro-enabled
workbook

Exactly the same as .xlsx, but with the ability to support Excel macros.

The default Excel format if macros are used in your model.

.xlsb

Excel binary workbook

An Excel macro-enabled workbook. The file information is stored in binary format rather than as XML documents.

This file format is approximately twice as fast as .xlsx at opening and saving Excel workbooks. This is particularly useful for very large files (greater than 10MB). This file extension cannot be used by non-Excel applications such as Bloomberg and Capital IQ, so if these systems access your Excel file, then this file format should not be used.

.xltx

Excel template

A template Excel workbook.

This format should be used if a standard Excel file is to be used as a starting pointfor other Excel workbooks.

.xltm

Excel macro-enabled
template

A template Excel workbook
with macro support.

This format should be used if a standard Excel file is to be used as a starting pointfor other Excel workbooks and contains macros.

Please do nothesitate to contact us, if you are having trouble viewing or accessing this article.

Copyright© 2016 AMT Training

Did you think that conditional formatting for constants (blue font color for example) was impossible? Well think again!   Create a new named range called cell has no formula. In the Refers to: box type the following: =NOT(GET.CELL(48,INDIRECT(rc,FALSE)))     How to create a new conditional...

Conditional formatting for constants in Excel18 January 2017Excel

Quicker keyboard shortcuts In Excel 2007, the ALT keyboard shortcuts were very slow. For example, if you pressed the keyboard shortcut sequence ALT+E+S+T too quickly (or the same speed as Excel 2003), Excel 2007 would simply not register the shortcut and therefore not run the command. Keyboard shor...

Excel 2010 the new features18 January 2017Excel

Data tables are one of the most useful tools for sensitivity analysis in financial modeling. They are both powerful and easy to implement. The majority of sensitivity tables are built using one or two variable inputs. While there is no direct way of increasing the number of inputs in Excel data tabl...

How to make a three way variable data table in Excel18 January 2017

Video liên quan