I want to use data in my first excel table to produce data in my second excel table elsewhere in my document, is this possible?
Hi Mac NorLog, To link data in one embedded Excel workshhet to data in another embedded Excel worksheet: . activate the source worksheet . copy the source cell . close the source worksheet . activate the target worksheet . use Edit|Paste Special, click on 'Link' and choose the Excel file format. This is best done after the document has been saved with the required name and in the required folder - otherwise the link may fail. -- Cheers macropod [MVP - Microsoft Word] "Mac NorLog" wrote in message news:05F7DC86-8418-47A8-8598-D4FF307BAA00@microsoft.com... >I want to use data in my first excel table to produce data in my second excel > table elsewhere in my document, is this possible?
Excellent, Thank You "macropod" wrote: > Hi Mac NorLog, > > To link data in one embedded Excel workshhet to data in another embedded Excel worksheet: > .. activate the source worksheet > .. copy the source cell > .. close the source worksheet > .. activate the target worksheet > .. use Edit|Paste Special, click on 'Link' and choose the Excel file format. > This is best done after the document has been saved with the required name and in the required folder - otherwise the link may fail. > > -- > Cheers > macropod > [MVP - Microsoft Word] > > > "Mac NorLog" wrote in message news:05F7DC86-8418-47A8-8598-D4FF307BAA00@microsoft.com... > >I want to use data in my first excel table to produce data in my second excel > > table elsewhere in my document, is this possible? > >
