I have large Excel files and am constantly refering to the data via Pivot Tables.
My problem is that when I add data and then refresh the pivot table, it will not pick up the new data.
If I right-click on the pivot table, Pivot Table Options, Data, Number of Items to retain per Fiels, Automatic or Max - nothing happens. If you type in the row number for the bottom of the data, it will only accept up to 32500 - not nearly enough.
The 'Help' shows this:
Number of items to return per field To specify the number of items for each field to temporarily cache with the workbook, select one of the following:
Automatic The default number of unique items for each field.
None No unique items for each field
Max The maximum number of unique items for each field. You can specify up to 1,048,576 items.
Note This setting is not available for an OLAP data source.
Is it a problem with Norton anti virus?
some help would really be appreciated - thanks
My problem is that when I add data and then refresh the pivot table, it will not pick up the new data.
If I right-click on the pivot table, Pivot Table Options, Data, Number of Items to retain per Fiels, Automatic or Max - nothing happens. If you type in the row number for the bottom of the data, it will only accept up to 32500 - not nearly enough.
The 'Help' shows this:
Number of items to return per field To specify the number of items for each field to temporarily cache with the workbook, select one of the following:
Automatic The default number of unique items for each field.
None No unique items for each field
Max The maximum number of unique items for each field. You can specify up to 1,048,576 items.
Note This setting is not available for an OLAP data source.
Is it a problem with Norton anti virus?
some help would really be appreciated - thanks
