Hi
I have quite large pivot table files in Excel 2003. When i copy a new source
piece of data into one of the tabs, and then refresh the pivot tables, i lose
all my formatting of the pivot tables (I.e Font Colours, borders etc)
Is there a way i can get the formatting bo be left alone.
Any suggestions.

Someone said write a macro, but i am wondering if there is a tick box i can
use to say leave the formatting alone.
Many Thanks
Matt

--
Matt Lynn

Message posted via http://www.officekb.com