I am using Excel 2000, on Windows 2000 professional operating system.
In my excel sheet i have a large pivot table, but after i refresh the data in the pivot table the first column(column A, which just shows the names of different regions in the world) shrinks in size and the text is not readable.
I have to then manually re-size the column each time which is a pain, since i refresh the pivot tables several times a day.
Is there some way i can keep the column width constant after an pivot table update??
In my excel sheet i have a large pivot table, but after i refresh the data in the pivot table the first column(column A, which just shows the names of different regions in the world) shrinks in size and the text is not readable.
I have to then manually re-size the column each time which is a pain, since i refresh the pivot tables several times a day.
Is there some way i can keep the column width constant after an pivot table update??