Sheet name in "Show Details" for a multi sheet Pivot Table

DaddyStu

New Member
Joined
Jan 30, 2014
Messages
1
Long time reader, first time post. Thanks people for years of help.

Excel 2007.

I have a workbook with a sheet per day, each sheet has a variety of 'jobs' as columns and a variety of people and kit as rows. Hours are manually input each day during the month.

Simplified version... These are two separate sheets 'M060114' and 'Tu070114'.

Monday
DigDrive
Dave45
Bill27

<tbody>
</tbody>

Tuesday
Dig
Drive
Dave27
Bill81

<tbody>
</tbody>

I have a Pivot Table on a separate sheet. This was created using the Wizard (ALT +D +P).

DigDrive
Dave612
Bill108

<tbody>
</tbody>

So far, lovely.

But when I double-click on a number or right-click and choose 'Show Details' I don't get the sheet names in the newly created information sheet. I get the Row label, column label and a list of the entries.

So if I clicked on 10 above...

RowColumnValue
Bill
Dig
2
BillDig8

<tbody>
</tbody>

That's fine with just a couple of entries but with about 80 columns and 250 rows spread across a month, therefore 30ish sheets, it's difficult marrying up the 'Show Details' sheet to the actual data.

So after all that, the question. Is there a way of getting the sheet name to appear in the 'Show Details' information sheet?

Regards

Stu
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Jerry Sullivan

MrExcel MVP
Joined
Mar 18, 2010
Messages
8,787
Hi Stu and Welcome to MrExcel,

Are you wanting to add the Sheet name of data source, or of the PivotTable that was double-clicked to show details.
(I think you want the data source, but please confirm).

The simplest way to add the sheet name of the data source would be add an extra field to the data source that holds the sheet name.
When you show details, that field will be included automatically.

If you don't want to add that field to your data source, it's possible to add that through VBA, but that's less simple.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,525
Messages
5,602,175
Members
414,509
Latest member
Cdavis7078

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top