It should automatically extend to as many pages as necessary to post your
entire spreadsheet. Are you doing a simple copy/paste? I just tried copying
a large spreadsheet of my own to test it and pasted it into Word. It
automatically extended to 5 pages in Word. I'm using 2007.
--
Stefan Blom
Microsoft Word MVP
"Tricia Butler" <Tricia But...@discussions.microsoft.com> wrote in message
news:7304BF00-1C8A-4E35...@microsoft.com...
Also, I selected a range to insert but the object is the entire spreadsheet
and multiple tabs. I broke each tab into a separate file, which is better.
However, I still can scroll down to blank lines and potentially just see
blank rows or columns in my Word document. Thanks again
--
Stefan Blom
Microsoft Word MVP
"Tricia Butler" <Tricia...@discussions.microsoft.com> wrote in message
news:46E56F05-54D6-4476...@microsoft.com...
What version of Excel & Word are you using? If 2007 like mine, you can
simply copy the Excel spreadsheet, open Word and paste it. After it has been
pasted, click on the little "paste options" icon and choose to either: keep
the source formatting and link to Excel or Match Destination table stype and
link to Excel. NOTE: Do NOT close the Excel spreadsheet until AFTER you've
made chosen one of these options. If you try to copy the spreadsheet and
close it before your paste it into Word, the option to "link" it to Excel
won't be available to you.
Once linked to Excel...any time you make changes to the Excel spreadsheet,
it will automatically change in the Word document as well.
I followed your steps and see how this works with pasting the link. I
believe I am at the crossroads of wanting the best of both worlds - I like
pasting as an object so I can simply change the numbers that vary in Word by
entering the Excel object, but that format does not seem to span across
multiple pages. I like this better than linking to the Excel spreadsheet
because others will be using the file in the future, and so the
"self-contained" format is nice and I won't have to worry about opening two
files and finding the "Update Link" function which I don't use that often.
However, I have to be able to see all the info, so at this point, the only
workable option seems to be inserting the spreadsheet as a link, and updating
the info in Excel. I am thankful to have a workable option, so again thanks
to you and Stefan Blom for taking the time to respond and having good
suggestions! ~tricia
--
Stefan Blom
Microsoft Word MVP
"Tricia Butler" <Tricia...@discussions.microsoft.com> wrote in message
news:3A8B84B4-6EC1-4CCC...@microsoft.com...
Please don;t post the same Q separately in multiple NGs.
--
Cheers
macropod
[Microsoft MVP - Word]
"cvarner" <cva...@discussions.microsoft.com> wrote in message news:CB696BCF-C731-4E62...@microsoft.com...