Pivot table irritation
This is causing me a lot of unnecessary work.
Whenever I format cells and do a refresh
the formatting reverts back to default.
Eg. I format date as Jan-05 when it shows 05/01
to Jan 2005. On entering new data and refreshing
it reverts back to 05/01.
I have selected keep formatting option in Table Option.
Is there something else I have to do to get the
formatting I want?
Help appreciated and thanks
|