linking spreadsheets within word

[rexi]

hi folks, got a problem.

I've created a word 2007 document and have inserted a couple of spreadsheet tables. The idea is to be able to input numbers in one and link the total to the front summary spreadsheet.

i've tried copying the total cell and pasting a link in the front summary page. when i update the detail numbers, the total does change.

however, i want to be able to email the document so someone can make a report, input numbers and have summary numbers on the front page. As soon as i email it, someone can access the detailed table & update within word, but the link and access to the front table comes up with broken link etc.

basically, how do insert spreadsheets in a word document save it and be able to circulate for use by others so that numbers entered can be linked through the word document...not updated from an external excel spreadsheet?

 

[scottylad2]

You could embed an excel table, on my phone right now so can't give the absolute path but its something like insert object, excel table or similar. Then rather than have them update one word doc, they get bothe the word and excel but they update the excel and it in turn updates the word doc

 

[rexi]

Hi, can you be more specific on how your idea works...

Ta..