-
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.
connection refresh
-
Using the Data Tab to Setup a real-time connection with a Website - Possible?
I would like to set up a workbook so that I can retrieve the front pages of various news websites, and am curious what the quickest way to do that would be, if it is possible. As a pilot run, I have been using the Data tab to try and retrieve the headlines from www.cnn.com, and have not had...- gravanoc
- Thread
- connection refresh data acquisition from web power query real time data
- Replies: 1
- Forum: Excel Questions
-
N
Excel connected to SQL Server - every new import causes REF! errors and issues with formulas
Excel 2016 - I have an Excel file that imports a table from SQL Server via a connection created with the Data->Get Data->From Database->From Sql Server Database. When I built the file, I imported the latest information from the SQL table, which created a table automatically in Excel, and then...- Nola111
- Thread
- connection refresh import import data rows table
- Replies: 5
- Forum: Excel Questions
-
J
VBA opens source data during refresh if source is locked
Hi all, I have found some odd VBA behaviour which I cannot understand. I have created a dashboard in excel, which pulls data in from a SQL database and also from another separate spreadsheet. I have written some VBA to refresh the data tables, assemble them into a single table and then refresh...- jb2_86_uk
- Thread
- connection refresh dashboard vba
- Replies: 0
- Forum: Excel Questions
-
E
Data connection not updating on parameter change
I have a data connection in my workbook that returns customer data. The connection executes a stored procedure on SQL Server that accepts four parameters. The fourth is a true/false value that I have populated using a checkbox tied to a cell listing the checkbox value. That cell is listed as...- El_Kabong
- Thread
- connection refresh data connection sql parameters
- Replies: 0
- Forum: Excel Questions
-
H
Pivot Table refresh only works in debug mode..!?
Hi all, I have a workbook which contains a link to an external SQL procedure to bring in data. The user will select parameters in the spreadsheet and run the macro to retrieve the data and then will be shown a pivot table of the results. The data actually goes initially into a normal table...- High Plains Grifter
- Thread
- break mode connection refresh pivot table refresh
- Replies: 13
- Forum: Excel Questions
-
G
Refresh Workbook Connections
Hi all... I'm looking for a way to refresh all links in a workbook by looping thru a collection of "connections?" that exist without having to hard code each one. The RefreshAll method works ok but then stops everything if there's an error (bad/missing connection). I want to trap the error if...- Glenn_Suggs
- Thread
- connecting to access connection connection refresh excel
- Replies: 3
- Forum: Excel Questions
-
X
Multiple pivot tables to connect to same (Access) source - refresh takes >50x longer in 2007 than in 2010
Hi, I have a datasource with some 140,000 rows in Access. In Excel I have a total of 17 pivot tables, all using the same connection, to run multiple analyses on the dataset. If I update the connection in Excel 2010 (with Access 2010), the update runs once and takes 8 seconds - so far so good...- xls_mycroft
- Thread
- 2007 access connection refresh pivottablecache
- Replies: 1
- Forum: Excel Questions
-
B
Refresh .CSV Connection - No Prompts
Hi i'm trying to refresh a connection in a workbook using vba, (using a refresh every ten minutes will take up too much resource), i want to avoid prompts coming on screen. So far this is what i have it breaks at: .Refresh BackgroundQuery:=False And comes up with: Sub Rifresh() pathfile...- Bench
- Thread
- connection refresh excel 2007 refresh connection vba
- Replies: 2
- Forum: Excel Questions
