Issue Exporting a report from Access to Excel

Hello,

I am currently having an issue exporting a report from access to excel. The
report contains a detail section and two footers that subtotal the detail by
two different groupings. When I export to excel, excel drops the name of my
subtotaled fields into the cell I want the subtotals in, creates an
additional column, and drops my formulas into the offset column. When I was
developing this report originally, I was able to export my data perfectly.

Does anyone know what I am talking about and can help. I want to avoid
setting up an excel template at all costs...

Frustrated,
-Jeff

.

Relevant Pages

  • Access 2000 report subtotals not exporting to Excel
    ... When I use either "Export" or "Analyze with Excel" to ... export a report with grouping and subtotals to Excel, ... group footer and it's subtotals does not get included in ... I have used the same report ...
    (microsoft.public.access.externaldata)
  • Re: Excel taking too much time to open (13 min)
    ... I suggest you try to find a more appropriate newsgroup that deals with Excel ... I have report in which I am using matrix. ... .So i used three matrix for diffrent subtotals. ...
    (microsoft.public.project)
  • Subtotal problem with Excel 2003
    ... We had an report running a macro setup on Excel 200 and ... 2003 the the subtotals do not appear on the report in the ... I understand that Excel 2003 subtotals ...
    (microsoft.public.excel.programming)
  • Excel taking too much time to open (13 min)
    ... I have report in which I am using matrix. ... ..So i used three matrix for diffrent subtotals. ... how to get the Excel opened quickly. ... subtotal on the Values obtained by Expressions(The Expression calcuates ...
    (microsoft.public.project)
  • Re: How do I keep multi-subtotals in the same order within the report
    ... Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003 ... > the report the order of the subtotals changes at least once. ... > the same order throughtout the entire report. ...
    (microsoft.public.excel.worksheet.functions)