I'm not advanced on Excel. A friend asked me how she could access the data on an Excel spreadsheet that had been embedded in a word document. I said it couldn't be done. She would need to access the actual spreadsheet. Am I right?
I'm not advanced on Excel. A friend asked me how she could access the data on an Excel spreadsheet that had been embedded in a word document. I said it couldn't be done. She would need to access the actual spreadsheet. Am I right?
Correct. If I remember correctly, Excel won't even recognize the spreadsheet the image was exported from. There are certain ways you can connect Excel with Word, but you can't create an interactive jpg with and Office Suite, sort of animating it or giving it a hyperlink.
You can embed an Excel workbook into a Word document, not as a jpg but as a spreadsheet, which will give you all the functionality.
Insert > Text > Object > Excel Workbook, which gives you a blank spreadsheet inside your Word document
Alternatively, if you have the data in Excel already, you can copy and paste special Worksheet object, with or without a link to the original data.
Kind Regards,
Out of the Hat
"Computers are stupid - they do EXACTLY what you tell them to"
If I've helped you with a problem, please say thanks by clicking the small star icon on the left.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks