Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Pivot Tables, pasting and formatting

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way to "unhook" a pivot table but keep the formatting? I need to send a number of sales report formats based on a pivot table, and using the auto format makes it easy to provide readable reports. The file size is too big, and I don't want to send the data along with the report. And when I copy and paste special, I can only paste the data, losing the formatting. Any ideas?

    Thanks

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Once you have pasted as values you should still be able to repaste again as "formats only"

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Duh! I knew I was overlooking something simple. Thanks! Talk about quick responses.

    Rudy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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