refreshing data in a pivot table changes cell format

P

pistolpete

I have set up a pivot table to transfer data from a table when information is
entered into certain cells. When i refresh the pivot table the format of some
cells in the table changes i.e. instead of the data being present in the
centre of the cell it drops to the bottom right, this is becoming really
irritating as i have to correct it all the time. i am planing on distributing
the workbook to a number of people so would like to know how this could be
prevented?

Thanks in advance for any help
 
L

Luke M

Unfortunately, the loss of formatting upon refresh of PivotTable is a known
issue by Microsoft. The generally reocmmended solution is to record a macro
of you formatting the table as desired, and then having it run after you
refresh.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top