Spreadsheet opening differently on different machines.

[Joseph]

I have several users who share a variety of spreadsheets.
The problem is that when some of them open a saved sheet,
the columns are not adjusted correctly for viewing (ie,
instead of seeing a number sequence of $250,000, they see
#######). It looks like th column are not setting
correctly when opening a saved doc, but only on some
machines. Is there a setting anywhere that would allow for
an adjustment of this? Does each machine have its own
internal "parameter" when it comes to cell size? Any help
would be appreciated.

 

[Paul]

I have several users who share a variety of spreadsheets.
The problem is that when some of them open a saved sheet,
the columns are not adjusted correctly for viewing (ie,
instead of seeing a number sequence of $250,000, they see
#######). It looks like th column are not setting
correctly when opening a saved doc, but only on some
machines. Is there a setting anywhere that would allow for
an adjustment of this? Does each machine have its own
internal "parameter" when it comes to cell size? Any help
would be appreciated.

It's probably that different machines have different printers (or at least
printer drivers) selected. Slight differences in how the printer driver
interprets the data for a particular printer cause minor variations which
show up as you describe. I know you may be thinking that you are looking at
the screen, not a printout. However, in order to "see what you get"
(WYSIWYG), Excel shows on the screen what will appear when printed; it's the
other way round from what you might at first expect. So a different printer
or driver will affect what you see on screen from the same workbook file.

You get ####### when the column is not wide enough for the contents. As
above, "wide enough" is partially dependent on the printer/driver. The best
suggestion I have for avoiding this is not to narrow your columns to the
limit, as this may be just beyond the limit for other printers/drivers.
Allow a little leeway and it's not a problem.