Totals vanish when exporting to Excel.

[nickfatool]

Another Excel related question..

I'm using the DoCmd.OutputTo method of transferring the
contents of a formatted report out to an Excel file.
The report contains 6 subreports and I've attempted to
line them all up so as to achieve a sense of continuity.
Everything is just fine except for calculated fields in
each subreports' ReportFooter (Sums and Averages of data
within the Detail). The problem is compounded with every
subreport, in Excel, the cells that should contain
precalculated sums actually contain an Excel Formula SUM
($C$2:$C$xxx) where xxx is the actual row the cell is on.
In effect it is reporting a running sum over all of my
subreports. Plus the average calculations in subreport footers do not appear at all.

Any clues on where I should start?


Thanks in advance..

Rob Dexter.