Can Excel duplicate Access's PivotTable Detail Data feature?

M

mwoolf

In Access pivottables, when you place a field in the data area, you can
specify "Detail Data". This displays the actual data instead of a summary of
the data.
Can this be cone in Excel?
 
D

Debra Dalgleish

No, that feature isn't available in Excel's pivot tables. You can
double-click on a data cell, to extract the underlying data. It appears
in a table on a new worksheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Embed the same Excel multiple times 0
Making "Change Highlighting" feature darker 1
Linking PivotTable Fields - Excel 2007 1
Internal Data Integrity (Type 4) Details Needed 1
Conditional Formatting Pivottables 0
Linking data in MS Word into Excel 5
Filter PivotTable dropdown items to match report filter 1

Top