peterbel
New Member
- Joined
- Jan 5, 2012
- Messages
- 28
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.
<colgroup><col><col><col><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>
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.
Cottage | DateStart | Surname | Add3 | Add4 | NoOfNights | Adults | Kids | HighChair | Cot |
Deco | Jul | Doyle | Cwmavon | (blank) | 7 | 2 | |||
Lee | Old Harlow | (blank) | 7 | 2 | 2 | ||||
Moderno | Maltby | (blank) | Sleaford | 7 | 3 | ||||
Provence | Juckett | California | 7 | 3 | 3 |
<colgroup><col><col><col><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>