Hi!



I have 3 (or more) separate Excel sheets in Word 2007. How to make references between Excel sheets, because Word don't tell me the sheet names. My formula is:

"Cell A1 in sheet1" + "Cell A1 in sheet2" = "Cell A1 in sheet3"

It would easy if all the values would be in one sheet, but it is not possible. Sheets must separated to different places in the document.

Hi Ilkks
You can first of all create a summary sheet in Excel that collates all totals that you need and then paste the summary sheet into Word using the "paste link" option. ANy changes made in Excel will automatically be updated in MS Word.
See the link below on how to use the "paste link" option:
http://wordprocessing.about.com/od/m...nkingexcel.htm
Tony

Thanks Tony, that link was very helpful!