data linking

  1. G

    Data link to another file not working

    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...
  2. C

    Is there an easy way to aggregate data from multiple spreadsheets into one?

    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...
  3. F

    Error: connection to another excel workbook (excel 2010)

    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...
  4. J

    Dynamic VLOOKUP table_array value

    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...
  5. C

    Update Data Links ALWAYS freezes!

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top