Pivot Table Extraction Formatting

[evil_moses]

Hi,

I have a query that is doing my head and cannot solve, and I hate that!

I have a pivot table based on a certain data set. When I double click on a cell in the data section to extract the data into a new worksheet, the format of the data in the new sheet is completely different to the format of the sheet containing the source data.

The main frustration of this is that the column widths are completely different to the source data (and all different) which means that column headers and cell data are being displayed on two lines within the same cell, as I have 'wrap text' checked for all cells. This of course also means that the row heights are all now completely different as well.

This problem is the same on every report, with the exact same formatting and column widths being used, so it's as if it is a default data extraction auto format. I just cannot find where to change it.

Any help would be massively appreciated, as I am fed up of having to re-format all data taken out of a pivot into something readable.

Regards

Marcus

 

[evil_moses]

Sorry, I forgot to mention that I have already tried unchecking the wrap text box and have also tried playing about with auto-format, and the formatting options within the pivot tables options (These only seem to apply to the table itself)

Thanks

 

[evil_moses]

Anybody got any ideas?