A Pivot Table problem

[peterbel]

I have a spreadsheet using several pivot tables, about 10 for every years analysis, over the last 7 years.
Up to now, apart from learning how to achieve what I want, I have not had a problem I couldn't overcome.
Each of the analysis years are in there own tab sheet and get data from one tab with the data in a Table.

I wanted to produce a new report, this weeks data, to produce as a print.
I created in a new tab, a new Pivot Table with the selected data for the print and chose to display it in tabular form.
All went well until I tried to change the format of the date the data starts so that it displayed as dd/mm/yy instead of mmm, which appears to be the default.
When I altered it, Excel wanted to alter the format of that date in all the Pivot Tables on all the other tabs, not what I wanted !!!

Am I trying the impossible, or is there a way to get what I want?

Below is a text paste of this table. It is the Jul I want to change.

[TABLE="width: 718"]
<colgroup><col><col><col><col span="2"><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Cottage[/TD]
[TD]DateStart[/TD]
[TD]Surname[/TD]
[TD]Add3[/TD]
[TD]Add4[/TD]
[TD] NoOfNights[/TD]
[TD] Adults[/TD]
[TD] Kids[/TD]
[TD] HighChair[/TD]
[TD] Cot[/TD]
[/TR]
[TR]
[TD]Deco[/TD]
[TD]Jul[/TD]
[TD]Doyle[/TD]
[TD]Cwmavon[/TD]
[TD](blank)[/TD]
[TD]7[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Lee[/TD]
[TD]Old Harlow[/TD]
[TD](blank)[/TD]
[TD]7[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Moderno[/TD]
[TD]Maltby[/TD]
[TD](blank)[/TD]
[TD]Sleaford[/TD]
[TD]7[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Provence[/TD]
[TD]Juckett[/TD]
[TD]California[/TD]
[TD]7[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Joyner]

Hello, If I understand correctly you would need to create the Pivot Table with a new cache or disconnect the single one you want to change -see this:

https://support.office.com/en-us/ar...-reports-87188806-0c24-4d17-b2f7-9e3a4a05542b

 

[peterbel]

Thanks, a very quick read of the first part of that link does look like the root of my problem.
I will have a good read of it later when I have time.
If it isn't the answer in the words of Arnie "I'll be back!"

 

[peterbel]

Yes that was it, thanks for pointing me to the answer.

Possibly related, is this why my other Pivot Tables that use that date from the master Table, as well as listing all the months of the year to select from, also list just the one date in the format "<12/12/2014" ?