+ Reply to Thread
Results 1 to 4 of 4

Page switch after refresh query via VBA

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Page switch after refresh query via VBA

    Hello

    While I am refreshing the query with VBA, after the code is end, I don't know why Excel switch to refreshed query page and select the query table and if the page is hidden its switch to any visiable page
    This happend even if I try to activate and select cell inside needed sheet after refresh code
    The problem with some version of office not all

    note
    background refreshing is off

    This is sample refreshing code
    Please Login or Register  to view this content.
    any idea about that?

  2. #2
    Valued Forum Contributor
    Join Date
    02-06-2014
    Location
    N/A
    MS-Off Ver
    N/A
    Posts
    373

    Re: Page switch after refresh query via VBA

    Have you tried using ActiveWorkbook.RefreshAll instead?

  3. #3
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Re: Page switch after refresh query via VBA

    No
    I don't want to refresh all

  4. #4
    Valued Forum Contributor
    Join Date
    02-06-2014
    Location
    N/A
    MS-Off Ver
    N/A
    Posts
    373

    Re: Page switch after refresh query via VBA

    I think this is probably a Microsoft bug that is low priority for them. I've experienced similar weird sheet / range activation behavior with Application.ScreenUpdating = False. Using Office 365

+ 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. Excel Power Query Refresh or Access Query - 2nd Query Run is faster
    By Steveapa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2020, 10:16 AM
  2. Refresh Progress Indicator Slowing down Query Refresh
    By rabbit_post in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2018, 07:56 AM
  3. Refresh All and Switch Worksheets via Macro
    By le tissier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2015, 07:49 AM
  4. Replies: 2
    Last Post: 09-29-2013, 06:15 AM
  5. Replies: 1
    Last Post: 09-28-2013, 07:11 PM
  6. Problem with selecting range with in query table after query refresh
    By shooter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2012, 11:55 AM
  7. Query Refresh-Enable Automatic Refresh Dialogue Box
    By Terri in forum Excel General
    Replies: 0
    Last Post: 05-06-2005, 04:06 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