freeze width of a column used by pivot table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

i'm using a pivot table report and want to fix the length of columns used in
that pivot table. is there any way to fix the width. i.e. when i refresh the
table, width of the columns should not increase. i dont need to show the full
contents of the text in those columns.

thanks,
.

Relevant Pages

  • RE: Pivot Table Data Problem
    ... Before I saw your post I have found a fix but I will try yours as well. ... "Jim Thomlinson" wrote: ... refresh your pivot table Twice... ... of using a pivot table to sort and collate the data. ...
    (microsoft.public.excel.misc)
  • RE: pivot reporting wrong info-riv
    ... having an issue with my pivot tables was wondering if anyone new how to fix. ... my pivot tables were created from my source data and worked fine but now ... is time consuming and i dont want to have to train others on how to do this ...
    (microsoft.public.excel.misc)
  • Re: Workload spreadsheet - pivot tables
    ... I think that's close - that will fix the problem in week 1, ... I get it to insert the carryover hours in week 2? ...  I have a pivot table ... or cross over a week boundary. ...
    (microsoft.public.excel.programming)
  • Re: Correctly Identify Seasons
    ... Can someone give me a suggestion as to how to "fix" my spreadsheet to ... properly display the "Seasons" information in a pivot table? ...
    (microsoft.public.excel)
  • Unorthodox Pivot Table Chart
    ... I have attached my pivot table chart and data. ... Does anyone know how to fix this? ... Tycon22's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16261 ...
    (microsoft.public.excel.misc)