Pivot table data source order

Sunclipse

New Member
Joined
Aug 31, 2006
Messages
13
Hi all,

I'm wondering if there is a way of checking the source data in the order it lists it in a pivot table.

I am trying to delete rows of information based on realizations ive come to using a pivot table. I can't figure out how to have the soure data show up in the same order so I can delete the right data without having to search through all 50,000 rows.

Thanks for the help!
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

mtb'r

New Member
Joined
Sep 8, 2006
Messages
42
Make sure "Enable Drilldown" is selected in the pivottable properties. (To check, right click on the table, select "table options". If it is checked, you should be able to double click on the result you want to check. The data that feeds into that result will be copied to a new worksheet that you can then look over. However, to delete the data, you will still need to find it in the original data set (maybe by using MATCH or VLOOKUP), and change it there. You will then need to refresh the pivot table to see the impact of the changes.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,053
Messages
5,545,740
Members
410,703
Latest member
yaronjoseph
Top