+ Reply to Thread
Results 1 to 2 of 2

updating problem

  1. #1
    Registered User
    Join Date
    06-04-2012
    Location
    israel
    MS-Off Ver
    Excel 2010
    Posts
    1

    updating problem

    Hi there,

    I have an on going problem with updating data from linked excel files.

    1. I'm working with excel 2010.
    2. The source files are excel 2007.
    3. The link formula is VLOOKUP, for example:
    =VLOOKUP(A3,'C:\mobiledep\marketing\Documents\[output (1).xls]Sheet1'!$A:$B,2,0)
    4. The data from the source files is not updated
    a. I need to open the source file.
    b. In some cases it helps, in other, the data still not updated, even when the source file is open.
    c. I drag the formula down the relevant rows – in some cases it helps – in other only part of the data is updated.
    d. When dragging the formula down the relevant rows – a window with the file location is popping out, and I need to select the file – but in some cases it does not help.
    e. In some cases I need to re-Wright the vlookup formula – and only after that – the data is updated.
    5. I have about 60 deferent files linked to my master file (the file that holds all the links).
    6. Also – having a similar problem with a pivot table – if the source file is not open – the data will not be updated when refreshing the pivot.
    All the option in the trust center are enabled or with prompt option (as far as I can tell – but maybe there are options that I’m not aware of).
    What should I do so the data will be updated in my master file when changes are being done in the source file – without having to open all the 60 file and/or re-typing the vlookup formulas?

    Hhhhhhhhelp……

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: updating problem

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1