+ Reply to Thread
Results 1 to 3 of 3

How to get column data to move with external data refresh

  1. #1
    Registered User
    Join Date
    09-22-2022
    Location
    Virginia
    MS-Off Ver
    Office365, 2010
    Posts
    8

    How to get column data to move with external data refresh

    Hi all.

    I have a spreadsheet that has an external data connection to an Access database file. Every 5 minutes, it refreshes the data. I created a column to the right of this linked data. I wanted to have a drop down menu where the user could essentially list that particular row as "ready" or "not ready".

    The problem I ran into is, when the data refreshes every 5 minutes, that data can get shifted to a new row, but the column I created to designate whether or not that particular row is "ready" or "not ready", does not move with the rest of the data.

    Is there a way I can link the data so it moves as the data gets updated? the data it pulls is filtered for "today", so it changes constantly.

    Thanks.

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: How to get column data to move with external data refresh

    so chances are the code to "shift the data to a new row" is probably set to copy a range, you'll just need to amend that code to grab the extra column
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    09-22-2022
    Location
    Virginia
    MS-Off Ver
    Office365, 2010
    Posts
    8

    Re: How to get column data to move with external data refresh

    I used the excel get data, linked the file, removed columns/data I did not need and imported it into the spreadsheet. refresh is set to 5 minutes. When I've done this before, I usually just set it for "insert cells for new data, delete unused cells", but for those spreadsheets, I don't have any extra columns, it's mainly just for viewing (I have the spreadsheets set to update data, save, and export as an html file for display on a large TV).

+ 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. External Data Refresh Failed
    By djspod in forum Office 365
    Replies: 0
    Last Post: 07-24-2018, 12:12 PM
  2. Replies: 1
    Last Post: 12-19-2016, 05:16 PM
  3. Refresh external data source?
    By Reeva in forum Excel General
    Replies: 13
    Last Post: 11-27-2006, 06:29 AM
  4. [SOLVED] Pivot column disappears after external data refresh
    By Fabio Missana in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-22-2006, 10:15 AM
  5. [SOLVED] Refresh external data
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2006, 07:50 AM
  6. external data refresh
    By shoreguy in forum Excel General
    Replies: 0
    Last Post: 03-07-2006, 02:35 PM
  7. [SOLVED] External Data Refresh not working
    By Mike B in VT in forum Excel General
    Replies: 0
    Last Post: 02-10-2006, 02:35 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