By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,606 Members | 1,796 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,606 IT Pros & Developers. It's quick & easy.

Forms/New/Pivot Table Wizard question

P: n/a
I have A97 and A2003. I created a form using the Pivot Table wizard.
This creates an unbound form with an embedded OLE object containing a
Pivot table in Excel.

There are 2 controls when the form is created; the Excel spreadsheet
object and a button to "Edit Pivot Table" The code for the button executes
Me!PivotTable.Verb = acOLEVerbOpen
Me!PivotTable.Action = acOLEActivate

Is there a way to refresh the pivot table? Each time I open the Excel
spreadsheet or dbl-click the Spreadsheet, I need to "refresh" the data.
Is there a way I can refresh the spreadsheet automatically upon
opening it?

When I open the spreadsheet, even after refeshing the data, the Filter
option is grayed out. I am using this spreadsheet to display a
schedule; The project name and date worked on the project are my row
headings. The employee name that works on the projects are my column
headers. The hours worked by each employee makes up the data area.

I would like to filter the records to show 1 week at a time if at all
possible.

Is there a way to set the filter of the Excel spreadsheet when it is
opened? Or pass a new recordsource (same data) with a Where clause?
Oct 3 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.