I have a financial application built on Excel. When I view the worksheets,
all of the column widths seem fine.
On occaison, when someone else views the same data in the worksheet, they
get the proverbial ###### showing the column is too small.
I know I can likely fix the problem by decreasing font size or increasing
column width. Also, I know that if I take protection off of the sheet the
user can change the columns (but I don't want to take a change on them also
deleting formulas, etc.)
However, is there some other setting that I can use that assures that
regardless who opens up the file, it uses settings from this worksheet rather
than taking on other user settings, i.e., if I don't have a column width
problem another shouldn't as well?
An suggestions glady accepted!
all of the column widths seem fine.
On occaison, when someone else views the same data in the worksheet, they
get the proverbial ###### showing the column is too small.
I know I can likely fix the problem by decreasing font size or increasing
column width. Also, I know that if I take protection off of the sheet the
user can change the columns (but I don't want to take a change on them also
deleting formulas, etc.)
However, is there some other setting that I can use that assures that
regardless who opens up the file, it uses settings from this worksheet rather
than taking on other user settings, i.e., if I don't have a column width
problem another shouldn't as well?
An suggestions glady accepted!
文章標籤
全站熱搜
