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!
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".
There are currently 1 users browsing this thread. (0 members and 1 guests)