Search notes:

Excel: Data -> Get & Transform Data -> Existing Connections

Data -> Existing Connections opens the Existing Connections dialog which shows all connections that are currently available and all Excel table in the current workbook.

Tabs

Connections

The Connections tab shows connections
  • in this workbook
  • on the network
  • on this computer (.odc (and other?) files)

Browse for more…

Browse for more opens C:\Users\username\Documents\My Data Sources.

Tables

The Tables tab shows Excel Tables.

See also

The object workbookConnection
Connecting to data sources from Excel
The connection property of the QueryTable Excel Object.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/Microsof...', 1745359326, '13.59.205.74', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/Microsoft/Office/Excel/GUI/Ribbon/tabs/Data/Get-and-Transform-Data/Existing-Connections/index(63): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78