I have a form set up to requery every 5 minute and this works fine, but within the form a have a subform with a PivotTable. I would like to stay on the form and have the PivotTable auto refresh at the same time.
I have a button "Edit PivotTable Object" on the subform, and as soon as I click the button it opens Excel and update the PivotTable, then I close excel and my form now show the updated pivottable, I would like to get this to happen at the same time as my form.
Thank you Gilbert.
I have a button "Edit PivotTable Object" on the subform, and as soon as I click the button it opens Excel and update the PivotTable, then I close excel and my form now show the updated pivottable, I would like to get this to happen at the same time as my form.
Thank you Gilbert.
