Announcement

Collapse
No announcement yet.

Pivot Table Source Data Display Problem

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Pivot Table Source Data Display Problem



    Hello All,

    I have set up a Pivot Table in Excel (not too familiar with PivotTables). When I double click on a cell to see the summarized underlying source data for that cell there is a quick flash a new spreadsheet is created and I see the COMPLETE data source table and not the summarized records that were used for the particular cell.

    Not sure why this is happening. I thought that by double clicking on the cell it would give you just those records used for calculation being performed. In my case I am just adding.

    Any ideas? I want the user to be able to see just those records and not all of them and have to filter through the table themselves.

    thanks in advance!

  • #2


    Re: Pivot Table Source Data Display Problem

    Hi

    Can you still see the new tab? It sounds as though there may be some code that executes on NewSheet event that activates the original datasheet. Check in the VBE Project Explorer under "This Workbook".

    HTH

    Robert

    Comment

    Working...
    X