Hi,

I have a Pivot Table (PT) that gives me all the analysis that I need but
what I want to do is email out sections of it to Area Managers so that they
see the basic layout with data relating to them but not be able to see other
Area Managers data. Is there an easy way to do this - dont want to take
screenshots etc and when I use the send to email recipient option it seems to
take the PT layout but still allows the user to change the PT to see other
information.

Any clues?

Reggiee