Pivot Table Formatting Issue

[Phixer]

I am trying to format parts of a pivot table, but the two lines listed at the bottom keep switching the formatting back to default, which I do not want. I am hoping someone knows of a switch I can throw to put things back.

This is a code snippet of the area with the problem. The whole code segment is huge (over two hundred pages printed out) and works fine.

Please Login or Register  to view this content.

at .ColumnGrand = True it removes all the formatting performed by the previous two subroutine calls. It does the same for .RowGrand, but I expect the problems are related.



These are the subroutines called from above.

Please Login or Register  to view this content.

I know it's not clean, but it is still a work in progress at this point.

EDIT: And before anyone asks why I don't just move the offending lines to before the formatting, because every time it re-sorts the table, it also removed the formatting, so these two lines need to be fixed.

[JosephP]

pivot table has a PreserveFormatting property you need to set to True and you should set the number format for the field not the cells. 200 pages of code...wow

your font formatting may change if you sort because it is applied to cells not the pivot field but you can use the pivottableupdate event to call your formatting code

[Phixer]

pivot table has a PreserveFormatting property you need to set to True and you should set the number format for the field not the cells. 200 pages of code...wow

I have PreserveFormatting set to True (on all the pivot tables, actually, because of everything being done to them), but was wondering if another toggle or switch somewhere will keep things stuck. Something esoteric that I might have overlooked.


And, yes, it is a lot of code. They hired me to automate a very complicated process because doing it manually was producing too many errors. Managed to improve time efficiency by 2-50 (depending on activity) and eliminate all errors from non-manual data entry.

Then they started adding more stuff in, now that they have time for it, such that I am never going to finish this. 244 pages of code and counting.