This support note applies to:
- AO Classic General Ledger (AU)
- AO Classic (NZ)
The "9/Data Type Mismatch” message can appear when opening Workpapers on a PC with Microsoft Excel 2010 installed.
Due to the version of Excel that FoxPro exports files for, there is a change required to Excel 2010 for the features within AO classic to work.
Microsoft added extra levels of security in Excel 2010 which by default do not allow a user to open a file format version of Excel before 2007 with full write permissions, 2003 file versions will also have restricted access.
Within Excel 2010 you can change the default security rights, please follow the instructions below to perform this task.
Open Microsoft Excel 2010
Click on the File Menu and click on Options. You will be taken to the Options screen
Click on Trust Center at the bottom of the menu. The trust centre screen will display
Click on the Trust Center Settings… button. The Trust Center screen appear
Click on the File Block Setttings Menu down the left hand side of the window
Ensure all the settings for Excel 2 worksheets and above are unticked.
Click OK to apply the changes.
The error should not appear again.
For further information see Microsoft Office 2010 Compatibility Statement
This article applies to Office 2010 32-bit. MYOB Accountants Office is not currently compatible with Office 2010 64-bit.
MYOB INTERNAL STAFF ONLY
Problem no: 11015051771
This error may occur on Windows 7 64-bit.