We recently upgraded to live version, 2016. In previous version 19 we were able to send reports with account codes to Excel without "indentations" and existing vertical lookup formulas worked well. NOw, however, it sends them with "indentations" which are unable to be got rid of easily. I feel that reports being sent to Excel should go with very little formatting, and certainly not these "indentations". I am awre that formulas can be written to remove them, but we shouldn't have to go to that trouble when it worked perfectly well with the old version. (see attached screen shots).
"Accounts codes transferring to Excel"
... View more