+ Reply to Thread
Results 1 to 3 of 3

How to update sheets in specific order

  1. #1
    Registered User
    Join Date
    04-21-2013
    Location
    Norway
    MS-Off Ver
    Excel 2016
    Posts
    15

    Question How to update sheets in specific order

    Hi

    I have a workbook with several sheets that I need to update in a certain order. I have one main sheet that is Connected to a SQL-database and gets data from that. Then I have some other sheets with different pivot-tables and graphs that is dependent on new, updated data from the main sheet. But how can I make one button that first updates main sheet and then updates the others (then based on the new data in main sheet)? For the moment I just press 'Update all' two times, but that is not a good solution.

    Thanks in advance
    Kjetil
    Norway

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    26,704

    Re: How to update sheets in specific order

    Hi,

    One way would be to 'build' the connections afresh each time rather than having them permanently in place.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-21-2013
    Location
    Norway
    MS-Off Ver
    Excel 2016
    Posts
    15

    Re: How to update sheets in specific order

    Not quite sure if I understand what you mean here. Could you explain in a little more detail you think? I Connect to the database via a ODBC-Connection, but do you mean a different way to Connect? Btw, the database is running on a different computer (main server).

    Kjetil

+ 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. [SOLVED] Creating location specific order sheets from master record
    By tommypkoch in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-01-2016, 12:40 PM
  2. Send Sheets to PDF in Specific Order
    By HB25 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2014, 12:11 PM
  3. [SOLVED] Sort specific visible sheets in an order according to cells in each sheet
    By Comisar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-14-2013, 06:57 PM
  4. update list with specific cell values in uncreate sheets (templates)
    By dmendes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-19-2013, 03:48 AM
  5. Macro to update data on specific sheets
    By jqb101 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-05-2013, 12:17 AM
  6. Macro Reqd to update Purchase order log, everytime a new purchase order is made
    By manthankanabar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 01:47 AM

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