(Msg. 9) Posted: Thu Mar 05, 2009 7:55 am
Post subject: Re: Paste large Excel spreadsheet into Word [Login to view extended thread Info.] Archived from groups: microsoft>public>word>pagelayout (more info?)
I've gotten to to same place with linking large spreadsheets into Word 2007,
using RTF. Works fine, intially. But after I close and reopen the Word
document, the link doesn't remain valid. I get "Error! Not a valid link" if
I use the Update Now button on the Links pop-up.
"Stefan Blom" wrote:
> You are welcome. >
> --
> Stefan Blom
> Microsoft Word MVP
>
>
> "Tricia Butler" <TriciaButler RemoveThis @discussions.microsoft.com> wrote in message
> news:3A8B84B4-6EC1-4CCC-8DD5-C01A0ABEE0F2@microsoft.com...
> >I have opened and saved the spreadsheet in 2007 - has evolved from 1997 to
> > 2003 etc.
> >
> > 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
> >
> > "USEN" wrote:
> >
> >> Hi Tricia,
> >>
> >> 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.
> >>
> >>
> >>
> >> "Tricia Butler" wrote:
> >>
> >> > Thank you so much for the responses. I did paste as an Excel object
> >> > because
> >> > there are formulas, and numbers I would like to have the capability of
> >> > changing with recalculation in the future. Is it possible to maintain
> >> > an
> >> > interactive format and have the spreadsheet still expand to multiple
> >> > pages?
> >> >
> >> > 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" wrote:
> >> >
> >> > > Note that if you pasted as an Excel object, the behavior you are
> >> > > describing
> >> > > is to be expected, since Word does not allow objects to extend across
> >> > > pages.
> >> > > Instead, make sure to paste in RTF (table) format, if necessary via
> >> > > the
> >> > > Paste Special dialog box (Home tab | Paste | Paste Special).
> >> > >
> >> > > --
> >> > > Stefan Blom
> >> > > Microsoft Word MVP
> >> > >
> >> > >
> >> > > "Tricia Butler" <Tricia Butler RemoveThis @discussions.microsoft.com> wrote in
> >> > > message
> >> > > news:7304BF00-1C8A-4E35-AEE4-731C60EBBB8E@microsoft.com...
> >> > > >I have a spreadsheet that one and a half pages long. When I insert
> >> > > >it into
> >> > > > Word, it cuts off after one page. Is it possible to have a
> >> > > > spreadsheet
> >> > > > continue to multiple pages in Word?
> >> > >
> >> > >
> >> > >
>
>
>
(Msg. 10) Posted: Thu Mar 05, 2009 10:07 am
Post subject: Re: Paste large Excel spreadsheet into Word [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I've stumbled on a work-around. If I open the Links pop-up, select my
problem link, and change the status of the "Preserve formatting after update
" checkbox, and then click the Update Now button, I'll get an update of the
link. That seems to work.
"MikeB" wrote:
> I've gotten to to same place with linking large spreadsheets into Word 2007,
> using RTF. Works fine, intially. But after I close and reopen the Word
> document, the link doesn't remain valid. I get "Error! Not a valid link" if
> I use the Update Now button on the Links pop-up.
>
> "Stefan Blom" wrote:
>
> > You are welcome. > >
> > --
> > Stefan Blom
> > Microsoft Word MVP
> >
> >
> > "Tricia Butler" <TriciaButler RemoveThis @discussions.microsoft.com> wrote in message
> > news:3A8B84B4-6EC1-4CCC-8DD5-C01A0ABEE0F2@microsoft.com...
> > >I have opened and saved the spreadsheet in 2007 - has evolved from 1997 to
> > > 2003 etc.
> > >
> > > 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
> > >
> > > "USEN" wrote:
> > >
> > >> Hi Tricia,
> > >>
> > >> 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.
> > >>
> > >>
> > >>
> > >> "Tricia Butler" wrote:
> > >>
> > >> > Thank you so much for the responses. I did paste as an Excel object
> > >> > because
> > >> > there are formulas, and numbers I would like to have the capability of
> > >> > changing with recalculation in the future. Is it possible to maintain
> > >> > an
> > >> > interactive format and have the spreadsheet still expand to multiple
> > >> > pages?
> > >> >
> > >> > 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" wrote:
> > >> >
> > >> > > Note that if you pasted as an Excel object, the behavior you are
> > >> > > describing
> > >> > > is to be expected, since Word does not allow objects to extend across
> > >> > > pages.
> > >> > > Instead, make sure to paste in RTF (table) format, if necessary via
> > >> > > the
> > >> > > Paste Special dialog box (Home tab | Paste | Paste Special).
> > >> > >
> > >> > > --
> > >> > > Stefan Blom
> > >> > > Microsoft Word MVP
> > >> > >
> > >> > >
> > >> > > "Tricia Butler" <Tricia Butler RemoveThis @discussions.microsoft.com> wrote in
> > >> > > message
> > >> > > news:7304BF00-1C8A-4E35-AEE4-731C60EBBB8E@microsoft.com...
> > >> > > >I have a spreadsheet that one and a half pages long. When I insert
> > >> > > >it into
> > >> > > > Word, it cuts off after one page. Is it possible to have a
> > >> > > > spreadsheet
> > >> > > > continue to multiple pages in Word?
> > >> > >
> > >> > >
> > >> > >
> >
> >
> >
(Msg. 11) Posted: Tue Nov 17, 2009 11:42 am
Post subject: RE: Paste large Excel spreadsheet into Word [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I've run into an issue with pasting from Excel 2007 into a Word 2007
document, using the "link" paste paste special option and pasting as RTF. For
the most part it comes in to Word great, but since it spans several pages, I
like to have the top line or lines "repeat as header" lines on each page. No
problem, I can go and modify the table in Word the way I like it.
The problem comes when the Excel spreadsheet changes and I want to update
the link in Word. All the formatting I have made to the table, such as header
lines, keep with next, unchecking the default "allow line to break across
pages", go away when I update the link. This happens whether or not I have
checked the "preserve formatting after update" in the Links configuration
editor.
Any suggestions?
Thanks,
Chris
(Msg. 12) Posted: Tue Nov 17, 2009 8:05 pm
Post subject: Re: Paste large Excel spreadsheet into Word [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
See reply in microsoft.public.word.tables
Please don;t post the same Q separately in multiple NGs.
--
Cheers
macropod
[Microsoft MVP - Word]
"cvarner" <cvarner.RemoveThis@discussions.microsoft.com> wrote in message news:CB696BCF-C731-4E62-9D1D-90C20DE2DBCB@microsoft.com...
> I've run into an issue with pasting from Excel 2007 into a Word 2007
> document, using the "link" paste paste special option and pasting as RTF. For
> the most part it comes in to Word great, but since it spans several pages, I
> like to have the top line or lines "repeat as header" lines on each page. No
> problem, I can go and modify the table in Word the way I like it.
> The problem comes when the Excel spreadsheet changes and I want to update
> the link in Word. All the formatting I have made to the table, such as header
> lines, keep with next, unchecking the default "allow line to break across
> pages", go away when I update the link. This happens whether or not I have
> checked the "preserve formatting after update" in the Links configuration
> editor.
> Any suggestions?
> Thanks,
> Chris
All times are: Eastern Time (US & Canada) (change) Goto page Previous1, 2
Page 2 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office