Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2009
    San Diego
    Thanked 0 Times in 0 Posts
    In Word 2007, I'm trying to get a large spreadsheet shown as an external reference to the actual file, but the best I can do is only get a portion of it on one sheet. Is there anyway to get the entire spreadsheet table to spread across multiple pages of a Word document and still maintain it's reference to the external file?

    Scott B.

  2. #2
    Star Lounger
    Join Date
    Jun 2010
    Lichfield, UK
    Thanked 0 Times in 0 Posts
    Hi Scott,

    I can't think of a way to get what I think you want. Maybe the answers to the questions below may help to get some sort of solution:

    1 - What version of Word / Excel are you using?
    2 - Does the consolidated document have to be a Word document?
    3 - Do you want the ability to amend the referenced spreadsheet from within the Word document or is it read only?
    4 - Is the referenced spreadsheet likely to change once it is pasted into/linked from the Word document?
    5 - If 4 = Yes then would those changes be done only from the Word document or would people be updating the spreadsheet directly?
    6 - Is the spreadsheet pagination static or is stuff being added to it which would then add new pages or change the position of existing page breaks?

    As I say I cannot think of a perfect solution but maybe answers to the above might open 1 or 2 options.


Posting Permissions

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