Hello Friends,
 
This is a small excel tip to convert a .xla or .xlam file to .xls or .xlsm file. This is a simple trick but really tricky one.
Follow the below Steps to do the same:
 
Double Click on .xla or .xlam file (Refer Pic 1)
 

 

File will open as shown in the below Pic 2

 

Pic 1 - XLA to XLS
 

Now Press ALT+F11 (Refer Pic 3) (Provide your password if Password protected)

 

Pic 2 - XLA to XLS

Pic 2 - XLA to XLS


 

Now Expand Microsoft Excel Objects as shown in below picture and Select This Workbook

 

Pic 3 - XLA to XLS

Pic 3 - XLA to XLS


 

Press ALT + F4 to see the property window of the “ThisWorkBook” Object

 

Pic 4 - XLA to XLS

Pic 4 - XLA to XLS


 

Set the IsAddin property to FALSE as shown in the below pic

 

Pic 5 - XLA to XLS

Pic 5 - XLA to XLS


 

Now you can see your Workbook. Save it as .xls, .xlsx or .xlsm.

 

Cheers 🙂 You are done !!