Questions tagged [external-data]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
16 views

Different behaviour between Excel 2016 and Excel 1907 (in Office 16)

I am trying to access data in a password protected file (source/source.xls) from another workbook (view.xls) via cell references. Private Sub Workbook_Open() MsgBox "Welcome to the contractor ...
0
votes
3answers
94 views

How to set up a 'TOTALLY' separate “pc” on an external drive?

I need to set up a separate Windows pc but without purchasing a separate hardware/pc. Why you ask? I need to setup a separate website/blog/business and I don't want that on my main pc/laptops ...
0
votes
0answers
46 views

Use cell with filename as value to 'link' to external sheet

I have an excel workbook with a sheet called Data where some filenames from other workbooks are stored. I want to refer to a cell from another workbook which filename I have saved in that sheet ...
1
vote
0answers
446 views

How can I use the value of an Excel cell in an Office Data Connection SQL query with an IN operator?

I've got an Office Data Connection running a SQL query against an external data source and using some dynamic parameters provided in cell in a worksheet. As long as I'm doing something like SELECT * ...
0
votes
1answer
24 views

Hide SDXC Card from desktop

how to hide an SDXC card from the desktop without ejecting it? I would like to have the SDXC card show in Finder, but NOT on the desktop. Is there a way to make it available in the finder? If I ...
0
votes
0answers
374 views

Excel Data Connection Always Has 1 Extra Row

I have an Excel file with a data connection to another Excel workbook. Every time that I refresh the connection, there seems to be one extra blank row in the table (with formulas, but there is no ...
1
vote
1answer
710 views

'From azure' button missing on Power Query ribbon

I have installed Power Query to access an azure SQL database. However I don't see a 'From azure' button which seems to appear in the screen shots in the tutorials. How can I activate this? Is there ...
1
vote
1answer
4k views

Excel does not import Guids (Unique Identifiers) when importing data using the “External Data” feature

When I try to use Excel 2013 to import External Data from a SQL Server Data Source, it does not import the Guids. The Query I'm using is: SELECT * FROM TABLENAME The table Structure is: ThingId ...
6
votes
5answers
29k views

How do I find the external data in an Excel workbook that appears to have none?

I an using Excel 2010. I have a template that, as far as I know, contains no external data sources: I cannot find any cell that refers to an external source. In the "Data" ribbon "Connections" tab ...
6
votes
2answers
35k views

How can I stop Excel from rapidly refreshing/flickering while data is being loaded from external sources?

I have an Excel spreadsheet with several charts on the same worksheet. Each chart's data comes from a different table. Each table's data is pulled from an Access database, and the connections for each ...