This error may be encountered when exporting using WIP listings to excel after applying Groupings in combination with calculations in the Advance Datasheet.
'Advance Datasheet Number: 91 Source: ExportToExcel <- aADatasheet'
In the screenshot below, we've grouped the datasheet view by the Code column, and applied a sum calculation to the Hours column:
When then attempting to export this to Excel the following error is encountered:
'Advance Datasheet Number: 91 Source: ExportToExcel <- aADatasheet'
The groupings and calculations are normally lost anyway when exporting to Excel, and then need to be redone in Excel. The datasheet export to Excel has always functioned like this.
This issue has been reported to Development, and will be resolved in a future release of Advance Practice Management.
To resolve this, as a workaround:
Don't apply any groupings or calculations to the datasheet view.
Export to Excel first.
Use Excel functionality to group and perform calculations.
If no groupings or calculations are made and the error still occurs, please uninstall and reinstall Office.