hidden rows unhide on their own
 

I have a client scheduling file in excel with about 800 rows. Non active
client rows are hidden. I don't want to remove those from the worksheet if
possible. The file is shared by 3-4 people using excel 2002 and 2003 (I
think that's all). Periodically, the rows have become unhidden without
anyone explicitly doing it. Is there a glitch anyone is aware of that might
be causing this? I'm suspecting some version incompatibility or something
like that but I haven't been able to narrow this down. We have encountered
other instances of excel doing things on it's own. One annoying example is
automatic recalculation being changed to manual which happens with occasional
regularity. Any thoughts on the subject would be welcome.
thanks,
Dave

hidden rows unhide on their own
 

How do you hide the rows?

Manually or by code or by filtering?

As far as the calculation mode goes.....................

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g

BTW.........not yet updated in 2007 version.


Gord Dibben MS Excel MVP

On Sat, 9 Aug 2008 11:42:00 -0700, Dave Murto
wrote:

I have a client scheduling file in excel with about 800 rows. Non active
client rows are hidden. I don't want to remove those from the worksheet if
possible. The file is shared by 3-4 people using excel 2002 and 2003 (I
think that's all). Periodically, the rows have become unhidden without
anyone explicitly doing it. Is there a glitch anyone is aware of that might
be causing this? I'm suspecting some version incompatibility or something
like that but I haven't been able to narrow this down. We have encountered
other instances of excel doing things on it's own. One annoying example is
automatic recalculation being changed to manual which happens with occasional
regularity. Any thoughts on the subject would be welcome.
thanks,
Dave

hidden rows unhide on their own
 

the rows were manually hidden. (painstakingly, I might add ;-) ). They've
stayed hidden for days or weeks, so I'm hunting for what might be the trigger
that releases them.

I've been aware of the recalc issue for a long time and have been trying to
stamp out every vestige of manual recalc I can find. I have hundreds of
spreadsheets but should have gotten nearly all. The manual recalcs have
cropped up occasionally but had not for quite a long time until recently.

"Gord Dibben" wrote:

How do you hide the rows?

Manually or by code or by filtering?

As far as the calculation mode goes.....................

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g

BTW.........not yet updated in 2007 version.


Gord Dibben MS Excel MVP

On Sat, 9 Aug 2008 11:42:00 -0700, Dave Murto
wrote:

I have a client scheduling file in excel with about 800 rows. Non active
client rows are hidden. I don't want to remove those from the worksheet if
possible. The file is shared by 3-4 people using excel 2002 and 2003 (I
think that's all). Periodically, the rows have become unhidden without
anyone explicitly doing it. Is there a glitch anyone is aware of that might
be causing this? I'm suspecting some version incompatibility or something
like that but I haven't been able to narrow this down. We have encountered
other instances of excel doing things on it's own. One annoying example is
automatic recalculation being changed to manual which happens with occasional
regularity. Any thoughts on the subject would be welcome.
thanks,
Dave

hidden rows unhide on their own
 

I know of no shortcut key combo other than Alt,o,r,u or CTRL + SHIFT + 9
that would unhide rows.

Do you have any new code running that may do the deed?


Gord

On Tue, 12 Aug 2008 11:35:04 -0700, Dave Murto
wrote:

the rows were manually hidden. (painstakingly, I might add ;-) ). They've
stayed hidden for days or weeks, so I'm hunting for what might be the trigger
that releases them.

I've been aware of the recalc issue for a long time and have been trying to
stamp out every vestige of manual recalc I can find. I have hundreds of
spreadsheets but should have gotten nearly all. The manual recalcs have
cropped up occasionally but had not for quite a long time until recently.

"Gord Dibben" wrote:

How do you hide the rows?

Manually or by code or by filtering?

As far as the calculation mode goes.....................

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g

BTW.........not yet updated in 2007 version.


Gord Dibben MS Excel MVP

On Sat, 9 Aug 2008 11:42:00 -0700, Dave Murto
wrote:

I have a client scheduling file in excel with about 800 rows. Non active
client rows are hidden. I don't want to remove those from the worksheet if
possible. The file is shared by 3-4 people using excel 2002 and 2003 (I
think that's all). Periodically, the rows have become unhidden without
anyone explicitly doing it. Is there a glitch anyone is aware of that might
be causing this? I'm suspecting some version incompatibility or something
like that but I haven't been able to narrow this down. We have encountered
other instances of excel doing things on it's own. One annoying example is
automatic recalculation being changed to manual which happens with occasional
regularity. Any thoughts on the subject would be welcome.
thanks,
Dave