Hidden Columns in Shared Workbooks

R

Rotary

We have noticed inconsistencies with respect to hidden columns for shared
workbooks. One of our office personnel cannot open a shared workbook without
all hidden columns changing to unhidden. The workbook has been saved with
hidden columns and opens as such for most users. If the user in question
opens the workbook, the columns are unhidden. If she hides the columns,
saves the workbook as unshared, closes the workbook, and reopens it, the
columns remain hidden. If however she hides the columns, saves the workbook
as shared, closes the workbook, and reopens it, the columns appear unhidden.
The other two users of this shared workbook do not have this problem. All
users are running Offce Excel 2003. Any help is greatly appreciated.
Thanks.
 
H

Henry

Rotary,

Sorry, not a solution, but I'm having similar problems with a shared
workbook & hidden columns in XL 2K.
Some users open the workbook and the column remains hidden, others open it
and the column shows?
Not much of a problem for me as there's only one hidden column which is a
helper column containing only 0s, 1s, 2s and 3s.
I can probably get rid of it by adjusting the dependant formulae.
Still, it can be annoying, especially where it pushes other columns off the
screen and you have to scroll to see them.

Henry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top