Pivot Table - changing from Access2000 to AccessXP

P

PBu

I have just upgraded from Office2000 to XP.

Access2000 used to open Excel for pivoting data in tables or queries from
within Access. This provided full Excel spreadsheet functionality in addition
to the pivot table. AccessXP does not do this. The pivoting takes place
within Access.

How do I get the same level of pivoting flexibility ? eg/ multiple sheets,
sheets with formulas running off the pivot ? ... from within AccessXP ie/
without exporting the data to Excel and "disconnecting" from the Access
database.

Hope someone can help !! I'm an "advanced-ish" Office user but not an IT
expert.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Write back from pivot table 1
Write back from pivot table 0
My new pivot table doesn't save 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Different ways to build Pivot table 1
Formula to Look up values from a pivot table 1
Excel 2013 Pivot Data Range formula reference problem 0

Top