Mystery - Experts stumped by Shrinking Column Widths
Posted by Susan on April 13, 2001 2:38 PM
Recap of Problem:
I write spreadsheets for 150 remote locations, 149 of which work with no problems. But at one location, the column widths I set appear to be automatically reduced to about 84% of the size I explicitly specified while developing, resulting in those nasty #### replacing large numbers. The files are fine when opened for the first time; the column width changes appear to happen during/after a save & reopen.
I've checked screen display settings (pixels), Excel Zoom, default font settings and default column widths, which are fine. The PC is a newish Dell running Windows 98. The models are locked and password protected, and the users are relatively low-skilled, so I don't think it's intentional hacking. Also, it's not just models I write that have the problem; even very simple models written by others and containing no VBA have the same issue.
Dave suggested imbedding an 'column.autofit' command in an auto-open macro, which would fix the problem. I appreciate the suggestion, but unfortunately, it would also destroy my formatting, so it's not really a viable fix.
Any additional ideas would be greatly appreciated!
Thanks - Susan