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?
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?