I have several worksheets in a workbook that are identical, only different
rows are hidden on each one so that the users can only see what pertains to
them. My rows keep "unhiding" when I do not want them to. It's a shock to
go into a spreadsheet and see all the rows unhidden, yet again. It's a huge
time-toilet to have to keep going back and hiding all the rows over and over.
What is causing this and how do I stop it? Thanks.
Eric - Excel 03

Do you have any macros on this workbook? Is someone changing row height?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Cobaum" wrote:

I have several worksheets in a workbook that are identical, only different
rows are hidden on each one so that the users can only see what pertains to
them. My rows keep "unhiding" when I do not want them to. It's a shock to
go into a spreadsheet and see all the rows unhidden, yet again. It's a huge
time-toilet to have to keep going back and hiding all the rows over and over.
What is causing this and how do I stop it? Thanks.
Eric - Excel 03

When you have hidden them have you saved the change? If not, this may be the
problem.

Please click on Yes if this posting were helpful to you.

"Cobaum" wrote:

I have several worksheets in a workbook that are identical, only different
rows are hidden on each one so that the users can only see what pertains to
them. My rows keep "unhiding" when I do not want them to. It's a shock to
go into a spreadsheet and see all the rows unhidden, yet again. It's a huge
time-toilet to have to keep going back and hiding all the rows over and over.
What is causing this and how do I stop it? Thanks.
Eric - Excel 03

No and No. There are many links to other workbooks (in the same folder).

"Luke M" wrote:

Do you have any macros on this workbook? Is someone changing row height?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Cobaum" wrote:

I have several worksheets in a workbook that are identical, only different
rows are hidden on each one so that the users can only see what pertains to
them. My rows keep "unhiding" when I do not want them to. It's a shock to
go into a spreadsheet and see all the rows unhidden, yet again. It's a huge
time-toilet to have to keep going back and hiding all the rows over and over.
What is causing this and how do I stop it? Thanks.
Eric - Excel 03

I always save after hiding and making a lot of changes. Thanks.

"trip_to_tokyo" wrote:

When you have hidden them have you saved the change? If not, this may be the
problem.

Please click on Yes if this posting were helpful to you.

"Cobaum" wrote:

I have several worksheets in a workbook that are identical, only different
rows are hidden on each one so that the users can only see what pertains to
them. My rows keep "unhiding" when I do not want them to. It's a shock to
go into a spreadsheet and see all the rows unhidden, yet again. It's a huge
time-toilet to have to keep going back and hiding all the rows over and over.
What is causing this and how do I stop it? Thanks.
Eric - Excel 03

One of our users is having this same issue in Excel 2003. It apears to be
the same bug as described in KB117128, although version 2003 is not listed in
the "Applies To" section. It apears that this bug is also in version 2003 of
Excel.

In your case you can likely just ensure that your users all have the
"Transition navigation keys" option unchecked and it should resolve your
issue.

In my case, the user wants the functionality provided by this option so
there apears to be no fix. If anyone from Microsoft is monitoring this
perhaps you could shed some light on this for us.

http://support.microsoft.com/kb/117128/



"Cobaum" wrote:

I have several worksheets in a workbook that are identical, only different
rows are hidden on each one so that the users can only see what pertains to
them. My rows keep "unhiding" when I do not want them to. It's a shock to
go into a spreadsheet and see all the rows unhidden, yet again. It's a huge
time-toilet to have to keep going back and hiding all the rows over and over.
What is causing this and how do I stop it? Thanks.
Eric - Excel 03

I will turn off the transision and see what happens. Is the bug fixed for
Excel 2007?

"JLR" wrote:

One of our users is having this same issue in Excel 2003. It apears to be
the same bug as described in KB117128, although version 2003 is not listed in
the "Applies To" section. It apears that this bug is also in version 2003 of
Excel.

In your case you can likely just ensure that your users all have the
"Transition navigation keys" option unchecked and it should resolve your
issue.

In my case, the user wants the functionality provided by this option so
there apears to be no fix. If anyone from Microsoft is monitoring this
perhaps you could shed some light on this for us.

http://support.microsoft.com/kb/117128/



"Cobaum" wrote:

I have several worksheets in a workbook that are identical, only different
rows are hidden on each one so that the users can only see what pertains to
them. My rows keep "unhiding" when I do not want them to. It's a shock to
go into a spreadsheet and see all the rows unhidden, yet again. It's a huge
time-toilet to have to keep going back and hiding all the rows over and over.
What is causing this and how do I stop it? Thanks.
Eric - Excel 03