Questions tagged [external-data]
The external-data tag has no summary.
12 questions
1
vote
0
answers
200
views
Excel refresh to import external data
I have a lot Excel files containing external data connections to a local database. I have sql queries to extract data. Since few weeks refresh is not working sometimes to one user.
I discovered what ...
- 11
0
votes
0
answers
271
views
How to display the last update of an external data source?
Following these instructions, I was able to insert external data (from WorldOMeter) into one of the sheets of my LibreOffice Calc spreadsheet.
I set the refresh interval to 43200 seconds (12 hours), ...
- 916
1
vote
0
answers
59
views
Visual Studio/Machine refusing external connections
Since going over to Windows 10, I have had numerous issues which I have mostly resolved.
One problem that I cannot get resolved is that my Visual Studio does not manage to get external link data. I ...
- 11
0
votes
3
answers
982
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 ...
- 1,153
0
votes
0
answers
686
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
0
answers
645
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 * ...
- 227
0
votes
1
answer
56
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 ...
- 1
0
votes
0
answers
473
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 ...
- 113
1
vote
1
answer
1k
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 ...
- 23
2
votes
1
answer
6k
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 ...
- 440
10
votes
6
answers
54k
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 the ...
- 383
6
votes
2
answers
46k
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 ...
- 6,390