formula references two embedded excel objects in Word doc

[Jeff]

I have a Word document that has two embedded excel objects that both perform
detailed calculations, and it would be nice if I could write formulas in one
that refer to cells in the other. I can't figure out or find any solution to
this; any ideas?

 

[Barb Reinhardt]

Try right clicking to Worksheet Object and Open for both of them and see what
you get. I was able to do it with a test document.