Excel 2007 ‘Edit Links’ Command deleting information

15 pts.
Tags:
Excel 2007
Excel 2007 workbooks
Microsoft Excel
microsoft excel functions
Microsoft Outlook 2007
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Subhendu Sen
    Try out this.... Select the cell in ur sheet, Home > Formulas > Use in Formulas & check the list, and identify any defined names want to delete Select Home > Formulas > Name Manager, Select one Name or more and click Delete To delete unwanted or no links: 1. Select Data > Edit Links to Files 2. Select the source workbook whose links want to delete, and then click Break Link. In the Find > type third bracket, start search, and delete any unwanted formulas CAUTION: Before doing that, please keep a copy of the original file. U can try on duplicate file.
    29,780 pointsBadges:
    report
  • Hporiginal
    If I break the link as you suggest in your second suggestion, then I would have to go back through the spreadsheet to put the formulas back into those cells. I want to know why did the program delete lines? Why didn't the command just bring back an error in the formula for those two lines or where ever it did not match up to the other tab?
    15 pointsBadges:
    report
  • Subhendu Sen
    Try out this.... Tools > Options > Transition and uncheck Transition Formula Evaluation
    29,780 pointsBadges:
    report
  • carlosdl
    "Try out this…. Tools > Options > Transition and uncheck Transition Formula Evaluation" I'm lost. What's that for ?
    70,220 pointsBadges:
    report
  • Chippy088
    Interesting. Was it a macro, or formula. Did it actually remove the lines, or as I suspect, it was a macro that filed those 2 lines with data from the file that was missing, so it carried on with the macro, ignoring the error state. It didn't show the lines you expected, because it couldn't find the file. This is a good reason for copying any data files referenced, to a location common to the files and the workbook.
    4,625 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following