Error: "9/Data Type Mismatch" when opening Workpapers in AO Classic
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.
MYOB INTERNAL STAFF ONLY
Internal Notes
Problem no: 11015051771
This error may occur on Windows 7 64-bit.