Column width changes from Excel 2004 to 2008

External Since: Feb 08, 2008 Posts: 3

When I open a workbook which was created in Excel 2004 in Excel 2008, the column width increases on every single column. The set width on each column doesn't change much according to the display (e.g. 5.50 column width in 2004 shows as a 5.57 column width in 2008), but on the display and on the printed page it appears about 20% wider. The font size looks the same in both spreadsheets. 
 
Any ideas why this is happening. My workbook has about 30 sheets and each column width is hand-set, so it would be a ton of work just to resize each column by hand to make the layout correct. 
 
Thanks. --Drew

External Since: Feb 08, 2008 Posts: 3

Hello Bob, 
 
I checked the fonts - exactly the same. When I resave the file in Excel08 (as a xls file) and open it with Excel '04, it looks the way it did before, i.e. correct. 
 
In fact, there's a graphic element in the spreadsheet which appears and prints stretched out in Excel08 but normal in Excel04. 
 
Regarding the print drivers, I'm running the latest and the issue is on the same computer, so it's the same printer driver for both Excel04 and Excel08. 
 
This happens in at least two different spreadsheets, which are multi-column full page things. Maybe it's in the formatting someplace but I can't figure it out. 
 
I'll keep trying different things, trying to figure it out. 
 
Thanks for any help you might have. 
 
--Drew