S
Steven
I am trying to export a pivot table from a form in Acccess to Excel. It
works fine unitl the maximum number of rows in Excel is reached. So, I am
thinking the following options would work, but I don't know how to implement
with code.
1) I could export the pivot table and only the rows that are making up the
current selection are exported. In other words, the basis for the pivot
table would be the current rows that are making up the displayed pivot result.
2) Export only the results (current display) of the spreadsheet. I would
think of this as similar to an Edit-Copy / Edit-Paste Special Values.
Any help would be appreciated. Thanks.
works fine unitl the maximum number of rows in Excel is reached. So, I am
thinking the following options would work, but I don't know how to implement
with code.
1) I could export the pivot table and only the rows that are making up the
current selection are exported. In other words, the basis for the pivot
table would be the current rows that are making up the displayed pivot result.
2) Export only the results (current display) of the spreadsheet. I would
think of this as similar to an Edit-Copy / Edit-Paste Special Values.
Any help would be appreciated. Thanks.