Export Pivot Table to Excel Sheet

S

Suntisuk

Hello

1. I create Pivot Table form in Access XP. After I click export to excel; In Excel, It shows all fields (Row and Column data) except Data Item in the middle of excel sheet. Excel shows Pivot Table Fields List to let me drag and drop the required field. Is it possible for Excel to create a Pivot table from Access without ask me to drag and drop

2. Exported pivot table shown in Excel is a dynamic table, That means I also able to customize or filter data as same as in Access. But what I need is opposite, I need only fixed data and format for exported pivot table. Is it possible

TIA
 

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

My new pivot table doesn't save 1
Export Pivot Table to Excel 1
pivot table calculations 0
VBA - exporting serial letters to single documents 0
How to embedd an excel table in access to generate pivot report 0
Access Adp Pivot Table Export to Excel 0
My Pivot Table Option are not working all icons are disabled 0
pivot table missing rows? 0

Top