+ Reply to Thread
Results 1 to 5 of 5

Pivot Tables

  1. #1
    Reggiee
    Guest

    Pivot Tables

    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

  2. #2
    SimonCC
    Guest

    RE: Pivot Tables

    How about protecting the sheet with a password before sending it out?

    -Simon

    "Reggiee" wrote:

    > 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


  3. #3
    Debra Dalgleish
    Guest

    Re: Pivot Tables

    If the data is in the file, other managers will be able to see it.
    Even if you protect the worksheet, it can be unprotected, and the data
    will be accessible.

    If you really want them to see only their own data, create a file with
    just their data in a table, and base the pivot table on that.

    Reggiee wrote:
    > 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



    --
    Debra Dalgleish
    Contextures
    http://www.contextures.com/tiptech.html


  4. #4
    Reggiee
    Guest

    Re: Pivot Tables

    Thanks people but not really the answer I wanted )-:

    Probably easier to do screenshots at this rate.

    Thanks anyway


    "Debra Dalgleish" wrote:

    > If the data is in the file, other managers will be able to see it.
    > Even if you protect the worksheet, it can be unprotected, and the data
    > will be accessible.
    >
    > If you really want them to see only their own data, create a file with
    > just their data in a table, and base the pivot table on that.
    >
    > Reggiee wrote:
    > > 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

    >
    >
    > --
    > Debra Dalgleish
    > Contextures
    > http://www.contextures.com/tiptech.html
    >
    >


  5. #5
    Del Cotter
    Guest

    Re: Pivot Tables

    On Mon, 26 Jun 2006, in microsoft.public.excel.misc,
    Reggiee <Reggiee@discussions.microsoft.com> said:

    >Thanks people but not really the answer I wanted )-:
    >
    >Probably easier to do screenshots at this rate.


    Screenshots would be a bit drastic. I would recommend
    cut-and-paste-special to a fresh new sheet instead. First paste the
    values, then paste the formats.

    Alternatively, link a template spreadsheet to your pivot chart in
    another spreadsheet, then, just before you save and send it to your
    managers, break the link. That way, all they'll get is the data that was
    linked.

    --
    Del Cotter
    NB Personal replies to this post will send email to del@branta.demon.co.uk,
    which goes to a spam folder-- please send your email to del3 instead.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1