Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HELP! Customer count issues... Pivot Table disaster | Excel Worksheet Functions | |||
Pivot table grouping issues | Excel Discussion (Misc queries) | |||
Pivot Table Formatting | Excel Worksheet Functions | |||
Pivot table range issues from report writer download | Excel Discussion (Misc queries) | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) |