Shared Workbook - Bring Back View

[CT Witter]

I'm working in a shared workbook and it has un-hidden several rows that need to be hidden. When a co-worker opens the same workbook it displays properly.

I suspect it has to do with the personal view property, but my dilema is that everytime I open the workbook it brings up my view, not the default.
How can I return to the default view? Is there a way to clear excel "remembering" my local view?

Thanks,
CT

 

[santeria]

If you define the View in the Sheet using vb, that usually fixes that... just depends on the nature of the view you want.

If it's particular, just record a macro, and you can get the elements from there.

And if placed in the Start up sheet, then that should bring out the right view for your requirements.

 

[CT Witter]

None of those situations applies. It is just a data entry spreadsheet that has several rows selected as hidden. Everytime I open the sheet, the rows appear. It just started doing it today, I use the sheet everyday and have never had a problem.

On my co-workers pc it appears as it suppose to. I really don't want to have to go through and manually re-hide all of the rows

Thanks for your suggestion.

CT

 

[CT Witter]

I figured it out!!! Go to View -> Custom Views and either delete the offending view or show another users "good" view.

Thanks,
CT

 

[kmscuba]

I have the same problem in my workbook. However, I have gone into Custom Views and deleted the views and then they pop back in there again. Is this suppose to happen and if not, how do I permanently delte the personal view?

Any help would be greatly appreicated!