Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » PERSONAL file defaulting to .xlsb

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

PERSONAL file defaulting to .xlsb

Resolved · Low Priority · Version 2007

Reply Fri 11 Nov 2011, 15:40Delegate Lisa said...

Lisa has attended:
Excel Advanced course

PERSONAL file defaulting to .xlsb

Hi

Is there a way to change the default setting so that when I create a macro it defaults to save as .xlsm rather than .xlsb? at the moment it automatically saves as a binary file and I can't see a way to change it.

thanks

Lisa

For upcoming training course dates see: Pricing & availability

Reply Fri 18 Nov 2011, 09:47Trainer Simon said...

RE: PERSONAL file defaulting to .xlsb

Hi Lisa,

Thank you for your question.

You can change the default setting for a workbook to *.xlsm via the Office button and then Excel options. However, this will apply to all workbooks saved in your current session.

Office button - Save option on the left hand side - Change the Save file format to macro enabled workbook.

I hope this helps.

Regards

Simon

Excel articles

· Become A Budding Picasso Using Excel
· How to check for and reduce errors in Microsoft Excel
· Learn How To Chart Your Deeper Data
· Some Simple Yet Less Common Excel Functions
· Simple Ways To Customise Excel

Please browse our web site to find out more about
best training excel vba and other Microsoft training courses.

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips