Exporting a Report to Excel

[Stan]

I am using the office link to convert an Access report to
Excel. When I view the Excel spreadsheet only two cells of
one line are populating the spreadsheet.

The report is based on a query and calculates various
totals.

What can I do to get the full report exported to Excel.

I need to have the summary totals on the excel report and
would perfer not to rebuild the totals in Excel.

 

[George Nicholson]

For reports that don't export cleanly into Excel I've *sometimes* had very
good luck with the following:

Export to Word instead, Select All (Ctrl-A), Copy (Ctrl-C)
Paste into Excel (and sometimes needing to Paste Special a 2nd time "As
text" over the existing formatting)

HTH,