.xla documents

[Loftus74]

I have somehow managed to convert a .xls spreadsheet into a .xla format.

Can anyone help in converting it back please?

 

[Firefly2012]

With this xla file open, go into the VBE (Visual Basic Editor) using Alt+F11 and locate this file in the top left Project Window.

Find the ThisWorkbook module within this workbook in the Project Window and double-click it to open it.

In the properties window (probably on the bottom left of the VBE under the Project Window), in the list of properties set the IsAddin property to False.

Back in Excel, the xla will now be visible. Select it and click File>SaveAs to save down as a non-xla file.

 

[Loftus74]

Firefly2012 that worked absolutely perfectly! Thank you so much for taking the time to do that, it's much appreciated!

 

[Firefly2012]

You're welcome

I've suffered the pain of having done that myself, and until you've resolved it the first time, it can appear very confusing as to how to sort it!