Windows 7 operating system. All MS updates current.
I am working with Office 2010 and attempting to link an Excel spreadsheet to a Word document. This has not been a problem until now. When I attempt to link an excel spreadsheet to a word document, all I can view in the word document is the path to the excel spreadsheet., similar to what you would see when creating a hyperlink. No data that is contained in the spreadsheet is displayed in the word document. However, if you go to print preview in the word document that is displaying only the path to the spreadsheet, you are able to view the data from the spreadsheet. This is creating a problem with layout design for the word document. I have been researching in an effort to correct the issue, but all I have found so far are instructions for locating the path of the linked spreadsheet, which in my case is actually visible in the word document itself, not hidden away somewhere in the setting/options.
I have been through as many settings as I can find in Word, like File --> Options searching for something that will resolve the problem. I have also right clicked on the path hoping to find something similar to the 'Remove hyperlink' option. I have not yet found anything to remove the path and display the data from the spreadsheet within the word document. I have even tried moving the files to a new location. Does not matter. I have checked other word documents with a linked spreadsheet. They are also experiencing the same behavior.
Attached are screenshots of the word document with the linked spreadsheet and the word document in print preview.