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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top