Stack Overflow
Stack Overflow

Questions tagged [excel-external-data]

40 questions
9
votes
2 answers

How to use parameterized query in Excel using column as parameter?

I am trying to develop a spreadsheet that can locate corresponding records in an external data source. So, let's say I have Column A with a list of identity values. I want to develop Column B, which perhaps shows a count of rows in the table with…
Jay Imerman
  • 4,475
  • 6
  • 40
  • 55
6
votes
2 answers

Error: "The query returned more data than will fit on a worksheet"

When I refresh my workbook, the following message pop-ups : "The query returned more data than will fit on a worksheet"? I have around 30 Sheets which have connections to external queries. How to check from which sheet this error is coming and how…
Toli
  • 109
  • 1
  • 4
  • 13
4
votes
2 answers

Add new table from external source using existing connection

I have an Excel 2013 workbook where I have created multiple tabs with each tab showing the results from a different view from an external database. I did this by clicking on DATA->OTHER DATA SOURCES where I then setup a connection and selected all…
user3165854
  • 1,505
  • 8
  • 48
  • 100
3
votes
0 answers

Excel Web Query Does not refresh

Is there a way to get Excel 2007+ to refresh a web query automatically? Scenario : I create a spreadsheet. Select Data/From Web. Type in the address of a web service that I know returns a valid response, select the returned xml and the data appears…
yuben
  • 693
  • 1
  • 9
  • 23
2
votes
1 answer

Force Excel to keep sheet name when referencing external tables

Is there a way to force excel from automatically "rewriting" the address of the external reference? Example When I mouse over and select a table in another workbook as a source, the formula bar shows this: =[WorbookName.xlsx]SheetName!TblName Once…
UEExcel
  • 23
  • 3
2
votes
1 answer

Append new data to an External Data table in Excel

If I have a table in Excel, populated via an external data connection, how can I refresh the data in such a way as to insert new rows for new data, but keep the old rows as well? For example, this is my table: Unfortunately the database that I'm…
dotNetkow
  • 5,053
  • 4
  • 35
  • 50
2
votes
3 answers

Excel macro to change external data query connections - e.g. point from one database to another

I'm looking for a macro/vbs to update all the external data query connections to point at a different server or database. This is a pain to do manually and in versions of Excel before 2007 it sometimes seems impossible to do manually. Anyone have a…
Rory
  • 40,559
  • 52
  • 175
  • 261
1
vote
1 answer

Suppress the message "Getting Data..." when importing from ODBC..?

In Excel 2007, when importing data via SQL/ODBC, it displays the message "Getting data" in the top-left cell of the import range. This occurs whether the query is run from the GUI or from VBA. Can this message be suppressed..??? There seem to be no…
spinjector
  • 3,121
  • 3
  • 26
  • 56
1
vote
0 answers

Make Excel external references relative

I'm using ClosedXML to create a really complex file referencing many external files with formulas. The file is generated on a server, so I can't use an absolute path, but the relative path is not working properly. Every time I try to create a…
Luigi Russo
  • 105
  • 6
1
vote
0 answers

How to prevent Excel Pivot Table External Data Connection from locking source Workbook for editing?

I have a couple Excel Workbooks with one serving as the local data entry Workbook and the other as the location for aggregating all the data that has been entered. The local Workbook also has a pivot table that uses an external data connection to…
RobsterCraw
  • 21
  • 1
1
vote
1 answer

How to avoid alert "You won't be able to undo the changes this action query is about to make to the data in a linked table or tables"

I wrote a code to call a module on the button click in Access form and when I click on d button, i recieve d following alerts: "You won't be able to undo the changes this action query is about to make to the data in a linked table or tables" and…
Toli
  • 109
  • 1
  • 4
  • 13
1
vote
1 answer

Trying to query an SQL database and need to convert a column to sort in excel

Before anyone yells, yes I know its stupid that there are numbers stored as varchars in the database I am referencing but there isn't anything I can do about it. Basically I have a column that is mostly integers stored as varchar but there are some…
mcunkelman
  • 21
  • 6
1
vote
1 answer

Change connection to external data source

I have an Excel 2013 file which shows data from an external DB2 database. The DB2 database has moved and I would like to change connection information to point to the new IP of the database. How do I do this in Excel? At the moment the only way I…
user3165854
  • 1,505
  • 8
  • 48
  • 100
1
vote
1 answer

Using Data from Web, how to login?

I have a macro that uses the "Data from Web" function. I have logged into the website (in Internet Explorer) that I'm pulling data from - but the results I get in Excel just keep telling me I'm not logged in. Is there a special way to login via…
BruceWayne
  • 22,923
  • 15
  • 65
  • 110
1
vote
0 answers

Excel External Data Connection crashing on other users

I have a tool.xlsx file that uses external data connection to Access DB (both are on a network drive, available to users with proper access rights). I have a vbscript (code below) that refreshes all the connections in that workbook. Everything works…
Adrian Chrostowski
  • 424
  • 9
  • 30
1
2 3