REPOST: Using Excel Pivot Tables within Access Questions

W

WIll

Hi

I have 2 related questions

1) If I add a field to the source table/query of an unbound PivotTable form which was created using the Pivot Table wizard, how do I get this new field to appear in the field list of the Pivot Table in excel without having to rerun the wizard from scratch

2) I'm trying to create a form where the user selects a value which then filters the source data of an unbound Pivot Table. When I use the value selected by the user to modify the filter statement of the unbound PivotTable form's properties, it has no filtering effect on the Pivot Table in Excel. How do I filter the source data of the Pivot Table
 

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

Excel does not accept text format! 0
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
pivot table missing rows? 0
Slicers and Calculated Items in Pivot Table 2
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
Changing pivot table ADO recordset 0
Change report firlds in pivot tables and charts with one selection 0

Top