Fix column width with when sychronizing a list to a Sharepoint sit

[Guest]

When I synchronize my Excel file with a Sharepoint web site, the column
widths change (i.e. get wider) in an attempt to allow all of the text
(wrappred) to be visable. This repeats itself with every saving iteration
which makes the file to big to print and I then have to manually reset the
column widths. Is there a way I can keep the column width the same when
synchronizing? Or, alternatively, is there a way I can easily restore the
column widths without have to manually resize them? Thanks, Bob.

 

[Guest]

Click on the Data. then, get the External Data Toolbar, if it didn't pop up
on its own. Click on the Format Button (Second from the left, most likely).
Under Data Formatting and Layout, remove the check for Adjust Column Widths.

tj