Hidden Columns & Rows in a Shared Wookbook
When a new user opens the file for the first time, they see all the rows and
columns that I or other users had already hidden. When the new user closes
the file, whatever view they had gets saved and the next time anyone opens
the file they are stuck with it.
I have noticed that under View, Custom View, I can see each person's
personal view file name. I believe these are only for their print settings
and the not the hidden file settings. Would it help to add a new view here?
It says it controls hidden rows and columns. Is this what needs to be done?
"Dave Peterson" wrote:
I'd check to see if the other users are unhiding those rows and columns.
Tom wrote:
I have a workbook that I started and I have since shared it with others. I
have numerous rows and columns thati have hidden. It seems that every time a
new user opens the workbook and saves it while I have it closed, the next
time I open the work book it unhides all rows and columns. Any suggestions?
--
Dave Peterson
|