Report output to Excel causes NULL error in OfficeXP in Sum(XYZ) field

[pdupreez]

I have a simple report showing daily despatches per month, including totals per day. When I export the report via VBA using DoCmd.OutputTo acOutputReport, "rptdaily", acFormatXLS, "C:\temp\rptdaily.xls", False, I get an #NAME# error in Excel(XP), which causes Excel to restart and recover.

However, if I convert the same report using the Export command from the Access menu, it translates correctly without error?

I am at a loss what the difference is. I do not have the same problem when I use Office97.