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.
Software/Hardware used: MS Office 2007, Excel 2007, Outlook 2007