Discussion on:

Anatomy of Word: Using Excel information in Word documents

The downloadable version of this article is available here:
http://techrepublic.com.com/5138-10877-6054994.html

Integrating Excel into a Word document is just one of many features found in Microsoft Office; what other features would you like to see explored by a TechRepublic tutorial.

I have one problem when I use the "paste link" option when doing the paste special of an Excel Worksheet Object. When I open the Word document, it automatically opens the Excel file it's linked to in the background. However, the Excel file is invisible to the desktop. When I try to open the Excel file separately I get the message that it's already open. I have to close the Word document and open the Excel file first. Anyone have a solution for this? My boss prefers the links rather than an embedded link to the worksheet.

i luv it

I do not understand why, after all these years, MS cannot better integrate word and excel.
- Why can't I insert a "word" sheet into Excel?
- Why can't I create a new "excel section" in Word? (i.e. keep a consistent header/footer but the main page is an excel table)
- Why can't I embed an excel table and have it appear as a normal table instead of just a picture? (ex. so that it can be more than a single page long, etc...)
- When linking two files (ex. paste-link an excel table), why is there no container format (ex. zip-like) that could ensure that the files always maintain the correct relationship when emailed and saved in another location?)
- There are so many ways Excel and Word could be drastically improved but MS moves very slowly...