Column changes when data is refreshed
 

Hi

I am a newbie at this so I hope I have put my query in the right place!

I am using Excel 2007 and I have a workbook that contains a Pivot Table.

Unfortunately when I refresh the Data the width of the columns changes and become too narrow to display the numbers in the column. Instead Excel displays a row of # symbols

I have tried checking and unchecking the 'autofit column widths on update' in options to no avail.

Any and all suggestions would be gratefully received

Eddie Mc