Excel formula not working when exported
Hi Lisa_BBP,
This is caused by the MYOB export putting something in cells that appear blank, that isn't a number. Using a formula that references that cell and expects a number, will result in the #VALUE! error.
This issue is visible when you look at the name of an account on export and its truncated, but when you press delete on the cell to the right, the full name of the account becomes visible. Its also identifiable when you 'ctrl+arrow' through a document which should take you to the next cell with data, but it skips whole sections with or without numbers as excel considers the entire area to contain information, like a whole column of DR despite only several rows containing actual numbers. This issued does not exist on Excel exports from the desktop AR package, just the cloud version of MYOB.
The Export process needs to be corrected to not export zero length strings.This is solvable in a roundabout way:
- Open find and replace (Ctrl+H)
- Leave the "Find What" field blank
- Enter "x" in the "Replace With" field
- Make sure to check the "Match Entire Cell Contents" box
- Click Replace All
- Now switch what you entered in each field. Put the "x" in Find what, and delete everything in Replace with
- Click Replace All
- All apparently empty cells should now be truly empty.
Yep, MYOB needs to improve their exporting processes.
