Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Cell Sizes are different on one computer

Status
Not open for further replies.

walkingseed

Technical User
Jan 1, 2006
12
US
I have a problem here with Excel worksheets. In our office, one person's computer opens Excel files with a different size for the cell than anyone else's computer. That is one every computer except his a cell that is 17.25H X 9.75W will open on his computer with a cell that is 17H X 9.63W. If he saves files that have cells that are 17H X 9.63W they open up on other computers with cells that are 17.25H X 9.75W.

Any ideas as to what may be causing this change?
 
Now open Excel, select all rows and columns by 'CTRL+A'. Change the row height and column width as per your requirement. 'Save As' this document in your XLStart folder as 'Template' with name 'Book.xlt'. Now every workbook created will be opened as per the settings in this 'Book.xlt'.

XLStart folder is available from Tools->Options->General. Take the 'Default File Location' path and inside that folder you have 'XLStart' folder. Something like this:
c:\Documents and Settings\<userName>\Application Data\Microsoft\excel\xlstart

Sharing the best from my side...

--Prashant--
 
Thanks for the try but...

The settings are identical on all of the computers. In fact, the computers are identical IBM T43 laptops. They have all been imaged with the same installation. I have also checked the files with other computers and software, including Macs running MS Excel, Solaris running StarOffice and Linux running OpenOffice and the files are rendered correctly in all of them.

None of the computers has a book.xlt or sheets.xlt file. In fact there are no xlt files on any of the computers. This would only be used if it is desireable to have all newly created workbooks formatted identically. A book.xlt in the xlstart directory will only affect the default format of newly created workbooks, not those workbooks that already exist. If I change the width and height of the cells from the default values, they should remain as set regardless of the book.xlt values.

It is as though there is an algorithm in the one computer that renders and displays the height and width of all cells in Excel files at 98.7% of the actual size.
 
Cell sizes are set in pixels. I am not clear what this means in this context but could it be something as weird as video drivers being different?
Just a longshot...


Gavin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top