Column Size:cant get a grip

For the first issue, after formatting the pivot table, right-click on the table, select options, then check the preserve formatting box.

For the second issue, select cell A4, then from the menu select Windows > Freeze Panes.

HTH

Jason

Originally Posted by jasoncw

For the first issue, after formatting the pivot table, right-click on the table, select options, then check the preserve formatting box.

For the second issue, select cell A4, then from the menu select Windows > Freeze Panes.

HTH

Jason

I´m not sure what u mean at the first issue. If u could decribe it more specific it would help
Second one worked thanks.

Your first issue is:

Got a major problem conserning my pivot-table. Everytime i update the table, the column change their size so u cant read the answers. Anyway to lock those to a specific size?

So after the pivot table is updated, go ahead and complete all of your formatting (column width, etc.). Next, right-click anywhere within the pivot table, and select Options. Check the option labeled 'Preserve formatting' and click OK. What this will do is save your formatting everytime the pivot table is refreshed, so you will not have to do this any more.

Jason