+ Reply to Thread
Results 1 to 8 of 8

How to find corrupted pivot table?

  1. #1
    Forum Contributor
    Join Date
    05-28-2010
    Location
    Antwerp, Belgium
    MS-Off Ver
    Office 365
    Posts
    170

    How to find corrupted pivot table?

    When I open my excel file I get this error:

    "The pivot table field name is not valid.."

    I know what it means and how to fix it, but since I have a lot of pivot tables in this excel, how can I find which pivot table is causing the problem?
    Or at least a list of all pivot tables in the excel?

    MS could really think to specify WHERE the problem is, instead of just throwing an error not clear about what..

    Thanks

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: How to find corrupted pivot table?

    Hi,

    I think you would require a loop, something like this
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Contributor
    Join Date
    05-28-2010
    Location
    Antwerp, Belgium
    MS-Off Ver
    Office 365
    Posts
    170

    Re: How to find corrupted pivot table?

    Quote Originally Posted by xlnitwit View Post
    Hi,

    I think you would require a loop, something like this
    Please Login or Register  to view this content.
    Beautiful! just what i needed.

    Thanks!

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: How to find corrupted pivot table?

    You're welcome.

  5. #5
    Registered User
    Join Date
    01-14-2019
    Location
    Qatar
    MS-Off Ver
    2010
    Posts
    1

    Re: How to find corrupted pivot table?

    sorry to ask... but where should I give this loop command...??

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,424

    Re: How to find corrupted pivot table?

    Hello jabuxolole and Welcome to Excel Forum.
    Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Note that since you have less than 10 posts you will not be able to include a link to this thread, however if you will let me know once you have opened your new thread I will include the link.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  7. #7
    Registered User
    Join Date
    04-21-2020
    Location
    Chicago, IL, USA
    MS-Off Ver
    Excel for Mac v16.36
    Posts
    1

    Re: How to find corrupted pivot table?

    I have this question, too

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How to find corrupted pivot table?

    Quote Originally Posted by GlennStrycker View Post
    I have this question, too
    If you have a question, please start your own thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Corrupted Workbook Recovery Removes Pivot Tables
    By goss in forum Excel General
    Replies: 1
    Last Post: 11-29-2015, 11:55 AM
  2. Help with VBA code to find bottom row in pivot table and fill table cell borders
    By Eric111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2014, 07:15 PM
  3. Pivot table error message but can't find the offending pivot table
    By dcoates in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-22-2013, 08:45 AM
  4. possible corrupted table
    By legolas in forum Access Tables & Databases
    Replies: 0
    Last Post: 01-16-2012, 05:35 AM
  5. Not able to find Average Value from Pivot table
    By booo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2010, 03:47 PM
  6. Find a missing pivot table
    By dondilbert in forum Excel General
    Replies: 0
    Last Post: 04-16-2010, 07:44 AM
  7. [SOLVED] Corrupted Pivot Tables
    By TimMalone in forum Excel General
    Replies: 0
    Last Post: 03-24-2006, 03:00 PM

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