Results 1 to 7 of 7

Thread: Error: PivotTable report cannot overlap another PivotTable Report
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2014
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Error: PivotTable report cannot overlap another PivotTable Report

    Hey all. I've found where other people have had this error but those solutions haven't helped me solve this one.

    Long story short I built this for another employee about a year ago and my memory is fuzzy on some specifics.

    There's only one PivotTable on the sheet.

    I get the typical error message when I hit refresh.

    The weird part is that I can move around my fields, remove, add, etc except for one field. It looks like I created some sort of calculated field of a date field. It's named "Years" and it has a little filter icon beside it in the PivotTable Fields area. When I try to remove that field from the Rows section, I get the overlap error message again. Does the same thing when I try to move that field to a filter, value, or column area.

    Any thoughts or ways I could troubleshoot this thing?

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,485
    Post Thanks / Like
    Mentioned
    46 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Error: PivotTable report cannot overlap another PivotTable Report

    Add this code to a new module in your workbook and tell us what the message says:

    Code:
    Sub HowManyPivots()
    msgbox activesheet.pivottables.count
    end sub

  3. #3
    Board Regular
    Join Date
    Apr 2014
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error: PivotTable report cannot overlap another PivotTable Report

    Quote Originally Posted by RoryA View Post
    Add this code to a new module in your workbook and tell us what the message says:

    Code:
    Sub HowManyPivots()
    msgbox activesheet.pivottables.count
    end sub
    Just comes back with 1. Odd.

  4. #4
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,485
    Post Thanks / Like
    Mentioned
    46 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Error: PivotTable report cannot overlap another PivotTable Report

    Are there other pivot tables in the same workbook that use the same source data?

  5. #5
    Board Regular
    Join Date
    Apr 2014
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error: PivotTable report cannot overlap another PivotTable Report

    Ok now we're on to something. When I delete all other pivot tables in the workbook (they're on separate sheets), I don't get the error anymore but the "Years" field goes away as well.

  6. #6
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,485
    Post Thanks / Like
    Mentioned
    46 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Error: PivotTable report cannot overlap another PivotTable Report

    Right click your date field in the pivot table and choose Group, then include Years in the grouping. That should bring back the Years field. Now you just need to figure out which of the other pivot tables was behind the error message. Did you have more than one pivot on any of your sheets?

  7. #7
    Board Regular
    Join Date
    Apr 2014
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error: PivotTable report cannot overlap another PivotTable Report

    Figured out which sheet was causing it. For some reason though when I go back and try to Group by Year, it tells me "Cannot group that selection". Edit - It can group but it basically just puts all the data up under "Group1". Edit2: Got it to work finally. Had to do some data integrity checks.
    Last edited by osscie3; May 10th, 2019 at 01:00 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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