itchyII
MIS
- Apr 10, 2001
- 167
Hi All,
I have an Excel file (Excel 2007) that has links to an MS Project file (Project 2003). Both files are stored on a Sharepoint site in the same directory. When I first created the links, everything was fine, and the vales from the project file were properly linked and showing properly in the Excel file. I updated the project file today (I had both files open at the same time) and when I went to see if the fields in the excel file were updated, I saw that they were not. When I verified the links, the status of the links said 'Not Apllicable'. I clicked on 'Update Values' and all the fields with the links now contain #REF. For the life of me, I can't get the values to show up again. I even deleted all the links and redid them and it still gives me #REF. What gives???
I have an Excel file (Excel 2007) that has links to an MS Project file (Project 2003). Both files are stored on a Sharepoint site in the same directory. When I first created the links, everything was fine, and the vales from the project file were properly linked and showing properly in the Excel file. I updated the project file today (I had both files open at the same time) and when I went to see if the fields in the excel file were updated, I saw that they were not. When I verified the links, the status of the links said 'Not Apllicable'. I clicked on 'Update Values' and all the fields with the links now contain #REF. For the life of me, I can't get the values to show up again. I even deleted all the links and redid them and it still gives me #REF. What gives???