Pivot Table Col Widths Copy-Paste-Link Picture

[cepes]

Hi:

I have a dashboard onto which I'm pasting linked pictures of columns from a pivot table.


Because of the PT column headers, the col widths vary. I can change the widths, copy, then paste them but when my dashboard is refreshed, the original PT col widths reappear.


Is the a way to keep PT col widths stable when pasting into a dashboard?


Thanks-

 

[NARAYANK991]

Hi ,


Have you tried what is posted here ?


http://blog.mcstech.net/index.php/training/excel-microsoft-training/excel-setting-constant-column-widths-in-a-pivottable/


Narayan

 

[cepes]

Narayan:

Perfect... Thank you. I learned something new today.


Charlie