+ Reply to Thread
Results 1 to 2 of 2

How can I format a pivot table properly for it to appear the same way in outlook?

  1. #1
    Forum Contributor
    Join Date
    07-16-2008
    Location
    USA
    Posts
    142

    How can I format a pivot table properly for it to appear the same way in outlook?

    I'm trying to paste roughly 600 lines of a pivot table (6 columns wide) into an email (Outlook 2010), but the format is not retained, particularly the row height. Mos rows double in size. I've tried every method of paste special values.

    When I use paste special as microsoft excel object, it works; however, it cuts off all the data beyond 19 rows. I'm also tried bitmap and image, but that only pastes a very narrow image that cannot be widened; therefore, making it unable to read/view.

    Is there a solution for this?

    Thanks!

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: How can I format a pivot table properly for it to appear the same way in outlook?

    Have you tried pasting as an image into PowerPoint and then copying out again?
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot table not sorting properly
    By Dast in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 06-10-2016, 06:43 PM
  2. Pivot Table not Totaling Properly
    By buckle2600 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-08-2012, 11:34 AM
  3. Pivot Table not suming properly
    By Dryclean in forum Excel General
    Replies: 3
    Last Post: 12-21-2011, 11:48 AM
  4. Pivot Table Won't Count Properly
    By bystarlight in forum Excel General
    Replies: 4
    Last Post: 07-30-2010, 07:12 AM
  5. Can't Use Pivot Table Properly?
    By jdomante in forum Excel General
    Replies: 3
    Last Post: 11-06-2009, 12:36 PM

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