(Msg. 1) Posted: Thu Nov 05, 2009 10:01 am
Post subject: Can Excel duplicate Access's PivotTable Detail Data feature? Archived from groups: microsoft>public>excel>misc (more info?)
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?
(Msg. 2) Posted: Tue Nov 10, 2009 8:07 pm
Post subject: Re: Can Excel duplicate Access's PivotTable Detail Data feature? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
mwoolf wrote:
> 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?
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office