Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: picture - Pivot Table & other

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,427
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    I noticed that Mark W. provides very neat formatted text at least with Pivot Table examples.

    1. Does the Table information come direct from Excel?

    2. Are there tools or shareware to take ss information and put it on this site or newsgroup sites?

    3. Microsoft apparently changed Pivot Tables from 97 to 2000. Were there also major changes form 2000 to 2002?

    Thank you Dave Patton

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dave, I'm using HTML for my PivotTable examples...

    1. First, I save the worksheet containing the PivotTable as .csv
    2. I change its extension to .txt, open it and paste it into Netscape Composer
    3. ...then use the Tools | Tableize | By Commas menu command...
    4. ...then View | Page Source
    5. Copy the HTML code and Paste into Word where I eliminate all ^p
    6. ...and, finally, paste the "compressed" HTML code into a reply posting.

    [ This Message was edited by: Mark W. on 2002-04-20 14:11 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,427
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    Thanks Mark

    I had hoped you had developed (found) a
    real efficient tool/program.

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
  •