-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
refresh query
-
R
Does Excel limit you on how many refreshes in a certain period of time?
Is there a limit to how many times Excel will allow a refresh to a query table within a certain time period? I am constantly facing an issue where I refresh my query tables and they take forever to update causing me to cancel the operation. Sometimes -- not often -- they actually complete in a...- rizzo93
- Thread
- power query excel refresh query
- Replies: 0
- Forum: Power Tools
-
D
Query.Refresh in For-Next loop hangs
I've written a routine to populate an excel spreadsheet with a list of geographic regions (cities, counties, congressional districts, etc) that are stored on a server. Each type of geographic region is stored on a separate sheet in the Excel workbook. The lists are then used to populate a form...- DG_Montana
- Thread
- excel not responding for loop refresh query
- Replies: 6
- Forum: Excel Questions
-
T
Access dataquery in Excel sheet locks Db while workbook is open
Hello Fellow Exceleers! Using XP/Access 2007/Excel 2007 I have a sheet with a data query that brings in an Access table. It is refreshed in a macro as follows: Sub UpdateRefData() Sheets("RefData").Range("A1").ListObject.QueryTable.Refresh BackgroundQuery:=False End Sub The...- TomPC
- Thread
- database locking dataquery refresh query
- Replies: 1
- Forum: Excel Questions
