pivot table formatting issues
Whenever I refresh my pivot table, I lose all custom formatting. For
example: I've changed a column of dates to be mm-yy, but upon refresh, i get 3-4 diff date formats. Also, my format borders is all wacky. Any idea what I'm doing wrong? |
pivot table formatting issues
You need to format the number by right clcking on on of the dates and then
selecting Field Settings - Number. That formatting should stick. I'm not too sure what you mean about borders but have you tried using the AutoFormatting that comes with pivot tables. that makes everything look spiffy... -- HTH... Jim Thomlinson "nickname" wrote: Whenever I refresh my pivot table, I lose all custom formatting. For example: I've changed a column of dates to be mm-yy, but upon refresh, i get 3-4 diff date formats. Also, my format borders is all wacky. Any idea what I'm doing wrong? |
pivot table formatting issues
On Thu, 06 Sep 2007 22:53:17 -0000, nickname wrote:
Whenever I refresh my pivot table, I lose all custom formatting. For example: I've changed a column of dates to be mm-yy, but upon refresh, i get 3-4 diff date formats. Also, my format borders is all wacky. Any idea what I'm doing wrong? Open Properties for that Pivot Table and uncheck AutoFormat checkbox. B. |
All times are GMT +1. The time now is 04:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com