Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Have link resize to Pivot table structure (Word XP)

    This post has 2 attachments. A spreadsheet with a pivot table, and a word document that has the pivot table pasted on the page with a link to the source spreadsheet. WHen the pivot source is modified in structure, pulling rows to colmns and visa versa, the table in word is updated, but not the object size. So most of the data cannot be seen in the pasted object.

    Is there a way to correct this?? I don't want to copy and paste each time the pivotstructure changes!
    Tx
    Attached Files Attached Files
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Have link resize to Pivot table structure (Word XP)

    No, linked worksheet objects refer to a fixed range. They don't resize themselves. Perhaps a pivot table is not the most suitable object for linking...

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Have link resize to Pivot table structure (Word XP)

    Darn...OK...I will live with that!
    Tx Hans
    Regards,
    Rudi

Posting Permissions

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