T
Team Red
I have just upgraded from Access 97 to Access 2003.
In Access 97, creating pivot tables could be done by using the Form's pivot
table wizard. Once created, these would open in an Excel worksheet
automatically. Once saved, double clicking on them would open a window with
snapshot of the pivot table and a button "Edit PivotTable" at the bottom.
Clicking on this button would open an editable pivot table in Excel.
In Access 2003, using the same wizard, the pivots open in Access's version
of a pivot table. While this is fine for most tasks, I really need the
flexibility and formulas available in Excel. I've tried exporting to Excel,
but this creates a read-only version.
Pivot tables created before the upgrade still open in Excel, I just can't
figure out how to get Access to treat the new ones in the same way.
In Access 97, creating pivot tables could be done by using the Form's pivot
table wizard. Once created, these would open in an Excel worksheet
automatically. Once saved, double clicking on them would open a window with
snapshot of the pivot table and a button "Edit PivotTable" at the bottom.
Clicking on this button would open an editable pivot table in Excel.
In Access 2003, using the same wizard, the pivots open in Access's version
of a pivot table. While this is fine for most tasks, I really need the
flexibility and formulas available in Excel. I've tried exporting to Excel,
but this creates a read-only version.
Pivot tables created before the upgrade still open in Excel, I just can't
figure out how to get Access to treat the new ones in the same way.