I have a word document which contains some charts based on data in an Excel spreadsheet. I update the word document frequently (it is as status report) by editing some of the supporting data in the Excel spreadsheet.
Now, I would like to store both the Word document and the Excel spreadsheet in a SharePoint document library. However, when I do this, the "link" between the charts in the Word document and the data in the spreadsheet is broken. When I try to edit the links in Word to point to the Excel spreadsheet in SharePoint, I get "You cannot enter a URL here" in the Open Document dialog box.
I'm using Office 2007. Is this something that might work in Office 2010?