I received a file from our corporate office. Some of the formulas in the workbook were referencing a location on a persons C:documents and settingsthatpersonmy documents. I wanted to change the reference to the existing file instead of the past months file it was looking at. I went into DataEdit Links highlighted the file I wanted to change then clicked on 'Change Source'. The program thought a second then seemed to refresh while removing two rows in the tab I was working. I have never heard of this happening and don't know what the true impact or implications could be. I do know that this one instance has jepardized my credibility with my co-workers at corporate because I had sent the file back with some changes but didn't realize until after the weekend the rows were not included in the file I returned to them. This file is updated every month with new information. I do know that on that particular tab, I did have to add two rows up above but that was in an earlier version I had sent with no problems. If anything, the links should have referenced the wrong cell because they would be out of sync. Any help would be extremely helpful.
MS Office 2007, Excel 2007, Outlook 2007
December 14, 2010 5:58 PM
March 11, 2011 3:48 PM