Results 1 to 5 of 5
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Pivot Tables - Copying to a static file (Excel 2k 9.0 SR1)

    I am creating a pivot table in excel based on data passed from Access. Once the pivot table data is in the structure that the user wants, is there a way to copy and paste this data as a static file. I have tried to copy and paste special as values and tried the go to, select visible only cells, however, still maintain the pivot table format. Any ideas?
    Regards,

    Gary
    (It's been a while!)

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Pivot Tables - Copying to a static file (Excel 2k 9.0 SR1)

    Select the Pivot Table, Copy it, go to the desired destination and Paste Special Value, and then paste Special Formats.

    Andrew C

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Pivot Tables - Copying to a static file (Excel 2k 9.0 SR1)

    Andrew,

    I tried to Paste the value as directed, however, still maintain the Pivot table format. Where is the Paste Special Value and Then Special Formats located. Is this the same as Paste Special and the conditional formats in the go to screen?

    <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    Regards,

    Gary
    (It's been a while!)

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Pivot Tables - Copying to a static file (Excel 2k 9.0 SR1)

    Try the Paste Special from the Edit menu, and select Values. If you do not wish to have the formatting from the Pivot Table do not bother with the second step (Paste Format).

    Andrew C

  5. #5
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Pivot Tables - Copying to a static file (Excel 2k 9.0 SR1)

    Andrew,

    I have tried your suggestion as well as numerous others, and can't get the pivot table to past without the pivot table formatting. A work around is to paste the table and then copy the data without the pivot filters to a new table.

    Thanks for your help... I am giving up on this for now..... <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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