[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

Pivot Error

Hi,

I have an error on refreshing all pivot tables

"The PT field name is not valid

I have hundreds of PT's, is there any wa i can find the PT this error is referring to?

Thanks
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
Rob HensonIT & Database AssistantCommented:
I often find that error comes up when there is a blank cell in the header row of the data.

Maybe you can check the data source quicker than checking individual Pivot Tables.

If the Data Source for any pivot is a dynamic range, it could be that the dynamic range is including a blank column.

Thanks
Rob H
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now