Linking across embedded xls spreadsheets

[snoproladd]

I'm building a Word 2010 document to submit a bid package to a contractor. I would like to be able to, across multiple Word pages, have small spreadsheets inserted to do basic totalling of amounts.

On the 1st page is a summary. Is there any way to link to the cells in the other embedded sheets and possibly even use the others in formulas?

Or would I have to build a larger xls worksheet and do the work within it itself and then link throughout the entire Word document to that one workbook?

[macropod]

Is there any way to link to the cells in the other embedded sheets and possibly even use the others in formulas?

Not easily or reliably. However, if you use Word tables with formfields for your inputs, totalling them in each table and outputting figures to the summary page is a snack.