+ Reply to Thread
Results 1 to 6 of 6

Links to data tables do not update

  1. #1
    Registered User
    Join Date
    08-30-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    4

    Links to data tables do not update

    Hi everyone
    I'm having a problem with data tables. Actually, not with data tables, but links to data tables. Calculation is set to be automatic and values within data tables update alright, but links to those values do no update. So you may have a certain value in one cell within a data table, for example cell B5, and a different value in another cell which is just a link to cell B5. Can anyone help me please?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Links to data tables do not update

    Is the referenced Table reference is same workbook or external workbook?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    08-30-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Links to data tables do not update

    It's in the same workbook

  4. #4
    Registered User
    Join Date
    08-30-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Links to data tables do not update

    Same workbook

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Links to data tables do not update

    Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

  6. #6
    Registered User
    Join Date
    08-30-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Links to data tables do not update

    Hi
    The problem is that when you open the workbook in another computer it works alright. Therefore, you won't be able to see the problem in yours. I figure that must be something to do with my definitions, but I can't quite see which definitions. Thanks anyway

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-06-2012, 12:31 PM
  2. Replies: 2
    Last Post: 10-23-2010, 08:36 AM
  3. broken pivot tables (and other data links)
    By Andy Warner in forum Excel General
    Replies: 2
    Last Post: 01-03-2007, 05:39 PM
  4. Links between Excel data and Word tables
    By epy45 in forum Excel General
    Replies: 4
    Last Post: 11-08-2006, 12:35 AM
  5. Suppress Update Links dialog AND don't update links
    By Paul Martin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-02-2006, 08:20 PM

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