Error: "Failed to create Excel spreadsheet ..."

This support note applies to:

AO Document Manager (AU)
AO Classic Document Manager (AU)
AO Classic Document Manager (NZ)
AO Document Manager (NZ)
AE Document Manager (NZ)
AE Document Manager (AU)

Article ID: 32000

In MYOB Document Manager you may experience the following error when you create an excel document using an Intranet Excel Standard:

"Failed to create Excel spreadsheet in 'C:\Documents and Settings\<user>\Application Data\Document Manager\Temp\a6ne9...' Reason VB Projects and XLM Sheets cannot be saved in a macro-free workbook".

Microsoft has made significant changes to the way how macros and VB projects are approached in Excel 2007. Due to this reason excel 2003 files (.xls) containing Macros or VB projects do not work with Excel 2007 an above.

The default file type for an Excel 2007 workbook has a *.xlsx extension. If you record a macro or write VBA code and then save the workbook as the standard 2003 file type (.xls), Excel displays the message that you are receiving now.

To resolve this error you need to save these ".xls" files as macro-enabled workbooks in 2007 format which is .xlsm. The *.xlsm files will then need to be re-imported into MYOB Intranet as a new version of the existing Excel standards.

To import a new version of an existing Intranet document

Open a new document in Excel, enter the contents in a new excel document and save it on the desktop. On the desktop, a new copy of the document appears.
From Intranet Administration, right click on the document and select Properties. The Properties window opens.
Go to the Versions tab and right click on the blank space in the box under the version. A drop down menu appears.
Select Import New Version. The Browse window opens.
Browse to the desktop, select the document created and click OK. The copy created on the desktop is imported as the new version of that document. A dialog box appears.
Choose Publish. The new version just imported is published. The dialog box closes.

For more related information, refer to the following: