Pivot Table Column Widths were punking me...

K

Kev in KC

Couldn't get the widths to stick, even with unchecking Autoformat and
checking preserve formatting boxes.

I had a formula outside the table, just doing a simple division. I had
clicked on the cells when building the formulas, and my formula looked like
this: =GETPIVOTDATA("Host Name",$A$3,"Roster Name",.....etc.

When I deleted that and just typed in the reference cells for my formula (
=C2/C3) it fixed my problem. I could set column widths and keep them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Table Preferred width is changed when pasting 1
Pivot tables and column widths 1
Pivot Table column widths 0
Pivot Table Column Widths will not stay fixed... 0
Table Column Widths Fixing Size in Word 2010 4
column width in autoformatted pivot table 5
Unable to set the desired column width for a table with merged cells 0

Top