I am very new to pivot tables but have created a pretty decent document that does everythign I need. I now have to share this document with others who could very easily screw things up accidentaly.

Without Pivot tables, I'd simply protect the cells I didn't want them to have the ability to change. If I do that, I get a "debug" error when I change sheets within the document.

Is there a way around this? If so, what is it?

Thanks