Results 1 to 2 of 2

Pivot table error message but can't find the offending pivot table

Threaded View

dcoates Pivot table error message but... 01-21-2013, 10:08 AM
dcoates Re: Pivot table error message... 01-22-2013, 08:45 AM
  1. #1
    Registered User
    Join Date
    11-06-2003
    MS-Off Ver
    2013
    Posts
    75

    Pivot table error message but can't find the offending pivot table

    I have a workbook with many pivot tables. When I refresh all I get a message that the PivotTable field name is not valid. I can not find the pivot table that is giving me the issue. I have gone to each of the pivot tables in the workbook and refreshed it individually, but do not get an error message. It is only when I refresh all that I get the message. I am using Excel 2010. I need a way to find the "offending" pivot table. Is that possible?

    The error message reads: "The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable, you must type a new name for the field."

    This has me stumped.
    Last edited by dcoates; 01-21-2013 at 10:12 AM. Reason: adding the error message as it reads

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1