can anyone help me on an error i get when i try and refresh a pivot table that i have created from data captured using Jet Express, the error reads "The Pivot Table 'pivottable1' could not be refreshed.The following error was reported: 'This command requires at least two rows of source data. You cannot use the command on a selection in only one row.'
I am fairly new to pivot tables but cannot for the life of me figure this error message out. The express refresh works fine, but the pivot table and any subsequent pivot charts will not refresh which i need them too.
Jet Express - Pivot Table Error