ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   formula references two embedded excel objects in Word doc (https://www.excelbanter.com/excel-worksheet-functions/198926-formula-references-two-embedded-excel-objects-word-doc.html)

Jeff

formula references two embedded excel objects in Word doc
 
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

formula references two embedded excel objects in Word doc
 
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.

--
HTH,
Barb Reinhardt



"Jeff" wrote:

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?



All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com