topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Sunday December 1, 2024, 11:46 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Best Way to Embed Excel Worksheet in Word Doc  (Read 4123 times)

questorfla

  • Supporting Member
  • Joined in 2012
  • **
  • Posts: 570
  • Fighting Slime all the Time
    • View Profile
    • Donate to Member
Best Way to Embed Excel Worksheet in Word Doc
« on: May 10, 2017, 06:20 PM »
It may not even be possible int he way that I would like to do. 
There is a place in the document that refers to use of function in an excel sheet to calculate cost for use by multiple persons.  ie: (Click here to use pricing tool.)  I can hyperlink these words to the Excel document but doing so on my system wont provide the correct link when the document is opened on another User's system.  This is a spreadsheet for calculating multiples of the various pricing shown in the Word Doc.

I was wondering if there as a way to literally "embed" these calculations into the Word Doc itself so they don't show up unless someone needs them and clicks the link for Multiple User pricing.  Or if the only way to make this work is to host the Excel file on our local network and link it such that it is pulled from the network when clicked.

Unfortunately,the document is for use by "all employees" and they may not be "In-House" when they click the link.  So it would require hosting on a web-accessible location done this way and require Internet access for clicking the link.

Are there Options I am not exploring?  Or a way to literally include the spreadsheet "hidden" in the Word doc?

ayryq

  • Supporting Member
  • Joined in 2009
  • **
  • Points: 101
  • Posts: 290
    • View Profile
    • Donate to Member
Re: Best Way to Embed Excel Worksheet in Word Doc
« Reply #1 on: July 06, 2017, 02:58 PM »
OK, here's some tips that might help you on the way to a solution. I'm using LibreOffice and I do not have access to Word or Excel; I'll be using "Writer" and "Calc"

First, you can embed a spreadsheet in a Writer document. This is done by "Insert → Object → OLE Object" in Writer, it's probably similar in Word. This embedded document may be "full" which will appear as a table might, or it can be an icon which when clicked will open in Calc.

Second, you can embed a specific cell from a Calc file into a Writer document (whether or not the files are linked as above). This is done by copying the cell in the Calc document (or embedded table) and then pasting it into the Writer document using "Paste Special…", then chosing "DDE Link". The resulting text will be live-linked to its source in the spreadsheet.

Hopefully these two tidbits will help you.
Eric