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

[DaddyStu]

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	Dig	Drive
Dave	4	5
Bill	2	7

<tbody>
</tbody>

Tuesday	Dig	Drive
Dave	2	7
Bill	8	1

<tbody>
</tbody>

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

	Dig	Drive
Dave	6	12
Bill	10	8

<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...

Row	Column	Value
Bill	Dig	2
Bill	Dig	8

<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

 

[Jerry Sullivan]

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.