My rows keep "unhiding" when I do not want them to

C

Cobaum

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
 
T

trip_to_tokyo

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.
 
J

JLR

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/
 
C

Cobaum

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

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

Similar Threads

Cannot unhide the hidden rows in my spreadsheet 3
Hide rows and prevent unhiding 2
How do I stop columns and rows from unhiding when I am using a fo. 2
Can't Unhide Rows in 'batches'! 3
how do I keep rows' formats when copying a formula? 2
Do NOT find in hidden rows? 4
Conditional hiding / unhiding of rows ? 2
what should i do if i don't want to see empty rows ? 3

Top