data linking

I have been successfully using a data link to connect two Excel files, one on my local drive and the other on a mapped network drive. Now, when I open the “local” file (which has the data link and formulas that use it), the cells with the linked data display the correct values, but then revert...

Hi All, Once per year my team sends out excel spreadsheets to 22 different departments to get their 4-year staffing plans. The templates we send out have pretty much all been standardized (we had to create one or two specialized spreadsheets, but I'll worry about these exceptions later). Our...

Hello everyone, I am having issues linking workbook B to my current workbook A. I know it's easy to do and I have done it in the past like this: Existing connections --> Browse for More --> Select file Then I would get a window like this one (View image: excel select tab) where I could choose...

Hello, Here's my situation- I've got a VLOOKUP set up in column D which references the (row based) value in Column A as the lookup_value, where Columns B and C are the table_array (returning C exactly) e.g. in D1: =vlookup(A1,B:C,2,false). This works as it should. Column C contains the text...

Hello, I have been frustrated by this problem for some time- Whenever I try to update the source for data links in 2007 (Data>Connections>Edit Links>Change Source) excel ALWAYS freezes! I've tried this on other machines as well and the same thing happens... useful info: -I am trying to change...