Losing formats when I refresh the pivottable

Hi,

I carefully set up the pivottable with cell borders, shading and size;  but after refreshing the data, all the cell formats are lost and I have to redo everything.  (Not a good thing when I deliver this to the client!)   What can I do to preserve the formats?

BTW, I'm using Excel 2003;  was this problem corrected in Excel 2007 or 2010?

 

RonLev

 

Question Info


Last updated April 24, 2019 Views 25,828 Applies to:
Answer
Answer

Hmm - interesting - external borders around a field seem to be preserved but internal borders are not.

Borders are preserved in 2007 and 2010.


Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk
Microsoft Excel MVP, Oxford, England. www.manville.org.uk

10 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.