Workbook automatically unhiding rows upon opening

[Omakbob]

We have a shared workbook that our admin staff updates, and our sales staff
accesses when on the road.

Recently, some of the admin's computers, and all of the sales staff's
laptops have begun unhiding all of the rows in this workbook when they open
it. For others, the hidden rows stay hidden.

I've been tasked with making sure the rows stay hidden upon opening, but I
cannot figure out why this is happening.

Help?

 

[CLR]

It could be the two groups are actually accessing two different similarly
named files.....could be same name in two different directories....problem is
common in companies which employ several different Operating Systems.....you
could go ahead and force the issue on your copy with a Before-Save macro, but
it would only affect YOUR copy, and if the problem is as I have suggested,
the results probably won't change......Your MIS folks should take a look at
the problem and make sure everyone is opening the same file.

Vaya con Dios,
Chuck, CABGx3

 

[Omakbob]

Unfortunately, all parties are accessing the exact same files.

 

[JP]

You didn't say what version of XL you are using. In 2003, go to
Tools>Share Workbook and click on the 'Advanced' tab. Uncheck the
"Filter settings" box at the bottom and see if that helps.


HTH,
JP

 

[CLR]

I know they THINK they are, but have you checked it out to be sure they
actually are.....some folks use desktop icons that don't update to new
versions of the file....etc.

Vaya con Dios,
Chuck, CABGx3