So, here’s the situation: a colleague of mine was working away in Excel, putting together all these complex interest calculations and linking them directly to various analytical cards, and then she just... moved on to her next chapter elsewhere, leaving me holding the bag. I recently upgraded my computer, and now it seems like all those vital connections have just vanished into thin air. Every time I try to open the file, I get that annoying little pop-up saying, 'This workbook contains links to other data sources,' but when I go ahead and click 'update,' nothing actually works—instead, the whole sheet just breaks and fills up with those frustrating #NAME? errors.
Does anyone happen to know where I should be looking or what specifically I need to tweak to get those links back in working order?
Does anyone happen to know where I should be looking or what specifically I need to tweak to get those links back in working order?