urgent help with output from pivot table

[rwalton159]

I have a spreadsheet of 10,000 lines of data.
Within the data there are fields which are colour formatted.

I have created a pivot table based on one of the headers (location), which shows how many records per location. Around 30 locations.

Upon double clicking a location, a new tab opens up with that location's data. However, all the colour formatting seen in the original data is no longer visable.

Is there a way to keep the formatting please?

Thank you
Richard

 

[rwalton159]

Anyone please

 

[rwalton159]

Must be a hard one!

 

[rwalton159]

Has anyone got any ideas or helpful comments please.

I am struggling with this.

Thanks
Richard

 

[Mike Blackman]

HI,

In short No, the only way is to write some VBA to format the newly created table to match the way you have formatted your pivot but there is no native way to capture this.

 

[Libra0099]

See related Thread! May be it will help you. Good luck!

http://www.mrexcel.com/forum/showthread.php?t=95343&highlight=Pivot+Table+Detail+Report+Format