Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: PivotTable Error: A pivot table cannot overlap another pivot table report

  1. #1
    Join Date
    17th May 2012
    Posts
    2

    PivotTable Error: A pivot table cannot overlap another pivot table report

    Hi!

    My question is: I am trying to refresh a pivot table and I get an error message "A pivot table cannot overlap another pivot table report". This is a spreadsheet that was passed onto me from another co-worker. To be honest with you I know how to bulid a pivot table but I do not know how to manipulate one. I read online about macros but I am not sure how to set one up to find the problem and then how to go on and fix it.

    Please advise.
    Thank you!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    19th January 2007
    Location
    South Carolina, USA
    Posts
    9,099

    Re: Pivot Tables

    Welcome to Ozgrid.

    Pivot Tables should be on their own sheet.

    Try moving the PT to a new sheet
    AAE
    ----------------------------------------------------

    Forum Rules | Message to Cross Posters | How to use Tags

  3. #3
    Join Date
    17th May 2012
    Posts
    2

    Re: Pivot Tables

    Thank you! I will try this. I appreciate your help with this

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 5
    Last Post: January 31st, 2012, 12:03
  2. CAD $10.00 Pivot Table/Report
    By Mr Code in forum HIRE HELP
    Replies: 12
    Last Post: March 22nd, 2011, 23:00
  3. Report or Pivot Table: Whats better to use?
    By tApL in forum EXCEL HELP
    Replies: 1
    Last Post: December 20th, 2010, 00:28
  4. Pivot Table Report With New Headings
    By kinger02 in forum EXCEL HELP
    Replies: 5
    Last Post: September 29th, 2007, 11:10
  5. Pivot Table Report on rotated table
    By critcho in forum EXCEL HELP
    Replies: 3
    Last Post: February 14th, 2006, 01:55

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
  •  
porno