Thread: Excel sheet references in Word
View Single Post
 
Old 05-06-2011, 04:35 AM
ilkks ilkks is offline Windows Vista Office 2007
Novice
  
Join Date: May 2011
Posts: 23
ilkks is on a distinguished road
Default Excel sheet references in Word
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.
Reply With Quote