Hidden Rows Appearing!! Shared Workbook

D

dandigger

I have a large workbook where I have many people entering data. When they
enter data, it gets accounted for on a seperate metrics sheet/tab. Cells B2
thru L33 are all forumlas so it's nice sized. I am using 3 of the rows for
accurancy counting and reference for some formulas and they are hidden from
view because the end user doesn't need to see them. (duh!!) Many times I'll
come in and these rows are viewable like normal. They keep switching back!
Has anyone heard of similar problems? Or is someone in this office manually
changing them back on me, without telling me? Could this be a Sharing problem
with Excel? It's not that big of a deal, it just makes the metrics look
unprofessional, and I feel I'm to blame. Thanks in Advance.
 
A

apples

i ran into this problem today also. its not someone else in the offic
messing with the workbook.

an answer to this one would be grea
 
D

Dave Peterson

Just a guess--maybe the user is autofitting all the rows.

Is there a reason you can't put your formulas on another worksheet and hide
that?

Or you could protect the worksheet (with the workbook not shared), then hide
those rows.

Make sure you unlock the cells that the users should be able to change.

And there's lots of things that users can't do on protected worksheets--so it
might be overkill.
 
Top