Saturday, 31 March 2012

Tip to open Excel workbook saved in any versions


How to  open the Excel work book saved in Excel 2007
from earlier versions of Excel.

There is an easy option available in Excel Work book
to achieve this.With this option not only you can open the Excel files saved in any higher version but  can  do other things like modify,save or send the same work book which can be opened from any versions of the Excel.

Follow the below steps :

save your file as an Excel Binary format (.xlsb), available in the Save-As menu scroll bar or  click the  Save As menu option which will open a dialog box choose the Save as type : as  Excel Binary format (.xlsb), as shown below
Save as dialog box with xslb option

Save in this format not only alllows you to open in any version of Excel work sheets but also reduces the size of the file.