disappearing columns

J

jcridgeway

I have a workbook on the network that is shared by three people and
myself and it consists of four worksheets. When I open the workbook it
opens to the first sheet. The first couple of seconds as Excel loads
all the data, focus is on the first sheet and I see all the columns
that I expect to see. As soon as the hourglass goes away it is as if I
had deleted columns 4 and everything to the right of it shifts to the
left. If I reopen the spreadsheet, I get the same behaviour everytime
I reopen it.
If I remove the share on the worksheet then the column that keeps
"disappearing" is gone for good.
How can I get that column to stay visible so that I can use it?
Thanks.
- jc -
 
R

Roger Govier

Hi

It sounds like there is a macro running on opening the file that hides
column D.
Maybe you are not supposed to use this column for any data entry.

If you do want to unhide it and look at the contents, then mark both
columns C and E, right click and choose Unhide.
I suspect there will be formulae in that column that should not be
overwritten by you, otherwise other parts of the sheet won't work.
 
J

jcridgeway

Thanks for responding, however, there are no hidden columns; it is as
if the column is deleted - I see it while the spreadsheet is loading
but then the column disappears and everything shifts left as soon as it
is through loading.
bizarre -

- jc -
 
L

Lisa Beach

Could there be a macro running that deletes the columns instead of hides
them? Maybe disable all macros and see if it still happens.

Thanks for responding, however, there are no hidden columns; it is as
if the column is deleted - I see it while the spreadsheet is loading
but then the column disappears and everything shifts left as soon as it
is through loading.
bizarre -

- jc -
 
J

jcridgeway

There are no macros running at all. I set macro security to the
highest setting and it does not even give me a warning. When I open
Tools/Macros, it shows no macros either globally or locally.

This is driving me up a wall - I NEED that disappearing column.
- jc -
 
D

Dave Peterson

I'd try opening excel in safe mode.

Close excel
windows start button|Run
excel /safe

The file|Open your workbook.

Does the problem continue?

If no, then you may have missed a macro--maybe it's in an addin. Maybe it's
behind an object you didn't check (ThisWorkbook or a sheet module).
 
K

KC Rippstein

Dave,
What an invaluable tip. Thanks so much for sharing that gem. I hope
Vista's pearl button keeps the Run functionality so that we may continue to
invoke a manual safe mode like you suggest here.
- KC
 
J

jcridgeway

Thanks Dave - that is a good tip to remember in the future, but for
this particular case it did not help.
I am thinking that it may have something to do with how it was shared.
This is a copy of the file that was on the network. When I go into
Tools/Share Workbook I see several names under "Who has this workbook
open now" even though it is just a copy and it is located on my
personal computer and nothing on my computer is shared. I have tried
removing the share, but all that does is save the workbook and when I
reopen it, the column that I only see for a brief second or two (the
one that I NEED) no longer shows up on loadup of the spreadsheet.
If anyone has knowledge of how these spreadsheets are shared and
insight into this problem, I would sure appreciate some insight.
Thanks.
- jc -
 
Top