Calculation in Excel Embedded in Word

Hello and I am thankful to find this forum. I have created a word document used for proposals and have embedded three separate excel sheets in the document. The sheets are each separated by lots of text and information which I removed to make the example easier. Each of the separate sheets calculate perfectly but I need a final Total on the document, but I can't figure out how to do it and add the sums from the other three sheets. I hope this can be done. Thanks

I can't seem to post my file here so I located it here: http://www.filehosting.org/file/deta...problem-2.docx
I attached the file in a response below

I have also posted the same questions in a few other forums:

https://www.excelguru.ca/forums/show...bedded-in-Word
https://www.mrexcel.com/forum/excel-...dded-word.html
http://www.ozgrid.com/forum/showthread.php?t=204375

We generally prefer that you upload the file directly to this forum rather than a link to a file hosting service. Click on "reply to thread" or "go advanced" then click on "manage attachments" to bring up the file uploader.

When I have done something similar, I have a cell/table in the spreadsheet that computes the final total, then link to that cell/table in Word. Is there some reason that you cannot have a fourth embedded sheet/cell in Word?

crossposted: http://www.ozgrid.com/forum/showthread.php?t=204375
https://www.excelguru.ca/forums/show...bedded-in-Word
https://www.mrexcel.com/forum/excel-...dded-word.html




Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Alan,

Sorry about that! I did not see that in your rules and I do understand the reasoning which is why on this forum http://www.ozgrid.com/forum/showthread.php?t=204375 I did post the links since I clearly understood. I will edit my post immediately.. my mistake

When I open your file, the fourth sheet has no formulas in it, so naturally the sums are not computed. You did not include the Excel file, so I cannot see why a simple =sheet1!E4+sheet2!E5+... formula cannot be entered.

Unless... there is no separate Excel file, and it is, as your example shows, strictly embedded in the Word document. Whenever I embed spreadsheets in a Word file, I am copying/pasting/as link from an existing Excel file. I have no experience working with embedded Excel sheets that are not part of an external Excel file. Perhaps that is the real problem/question -- can you link two separately embedded spreadsheets together like this. That, I don't know how to answer.

I understand your logic using =sheet1!E4+sheet2!E5, but I can't seem to do this and refer to the actual sheets that are in the doc.

That is the way that you make external references in a regular Excel file. tabname!A1 to access a cell in a different tab in the same file or '[bookpathname]tabname'!A1 to reference data in an external workbook. It seems that, if you can figure out what to put for "[bookpathname]tabname" in these references, it should work. However, I wonder if the problem is that there is no "[filename]" equivalent for such an embedded spreadsheet, and that is why you have not found a way to link embedded spreadsheets together.

My only advice at this point is to pull these tables out of Word and put them in their own Excel file. Then you can easily perform the desired summations. You can then embed a link to the external file/ranges in Word using the Copy/Paste special/as link command. (This is my recommendation, in part, because I do this quite frequently and it has generally worked well for me).