Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Pivot Table Source Data Display Problem

  1. #1
    Join Date
    15th February 2007
    Posts
    1

    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!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Location
    Berkshire UK
    Posts
    426

    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

    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. Reformat Data for Pivot Table Source
    By ryckiej in forum EXCEL HELP
    Replies: 4
    Last Post: May 31st, 2007, 12:24
  2. Replies: 9
    Last Post: September 12th, 2006, 10:07
  3. Pivot Table field not in data source
    By Dog in forum EXCEL HELP
    Replies: 4
    Last Post: April 25th, 2006, 01:13
  4. Pivot Table Refresh and Data Source
    By Alphy in forum EXCEL HELP
    Replies: 2
    Last Post: November 16th, 2005, 22:24
  5. external data source name for pivot table
    By davidblezard in forum EXCEL HELP
    Replies: 2
    Last Post: September 9th, 2004, 04:24

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