On my pivot table i have formatted the sub total rows as "bold" and
"aline right".

Each month fresh data is dropped into the base table, so long as the
number of rows is the same each month everything is fine.. but if
there is an extra row in the base data then although that row feeds
through into the pivot ok.... all of the formatting is lost.

Is there a way to retain the pivot formatting even though the base
data may vary each month.(I have already set the table options to
"preserve format" and have unticked "auto format")