Hi,
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.
James.
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi James,
It is hard to say without looking at the report itself but it sounds like you may have just created the pivot table and pivot charts slightly out of order. After using the Table Builder to create your report, run the report so you see the complete table. While there in "Report Mode", select the table created by Jet Express and add your pivot table. Be sure to have multiple rows of information showing in your pivot table and then you can create your pivot chart. Each time you run the report, your pivot table and chart should automatically refresh.
Are these the steps you took? If you are still experiencing problems then maybe a more detailed explaination on what you are doing may be needed. -
Jet Reports Historic Posts Hi James,
I forgot to mention in my last response that you should also make sure you are using "TableName=" in your NL(Table) function. This will ensure that the pivot table will be updated when you run the report again. I copied this from the Jet Express Help:
"TableName=" Specifies the name to use for the Excel table object created by NL(Table) with the name in the Filter parameter. Use this to refer to the table by name from a Pivot table.
Does this help? -
Jet Reports Historic Posts This error could be caused by a few different causes.
Here's a link to a 3 minute video that demonstrates how to diagnose this issue and how to resolve two of the most common causes.
https://jetreports.viewscreencasts.com/38d74ba9e984418e9de667cc2f139c6a#
I hope this helps.
Steve
Please sign in to leave a comment.