When you have 2 Excel spreadsheets embedded in a Word document, is it possible to one reference a cell value of the other one?
I was able to do this today in XL 2010 and I'm sure it's similar in earlier versions. Create two worksheet objects in Word. Then right-click on each of them and choose Spreadsheet Object>Open. With both open, link from one to the other, save them and close each. The links then update within Word.