Excel Column Width

[BenWilliams]

Hi,

One of our users is experiencing the following:

After opening an Excel sheet all the column widths that she has set are in place and in line, showing all data. However, when she saves the document, without any changes, closes and re-opens the same document certain columns have altered their width, displaying '#####'. The data is still there, she just needs to reset the column the column width.

I have searched all over for a solution, as it seems that this problem is rooted within her Excel settings, as the the document(s) work fine on my machine. Well, the one's she showed me anyway.

Can anyone point me in the right direction?

Much appreciated.

n.b. Could this be a problem with text size maybe?

 

[JustinEzequiel]

just an idea...
under 'Tools'-->'Options'
choose the 'General' tab
check the 'standard font' settings
particulary the 'size'

 

[BenWilliams]

Sorry, that does'nt answer my original question. Why does it change by itself??

 

[JustinEzequiel]

if her standard font (size) is different than the standard font where the workbook was originally created then saving the file may change the font of the cells to her settings

 

[rpierle]

I have had this problem before and there was some issue around autosizing the columns. Try setting the columns to a fixed width like 17, then save the file and re-open. If this works, she may have been using the autofit feature and there was something funny going on...for lack of a better technical term. Not sure why. Let me know if this works.