external data connection

Hi all I have a SharePoint list exported to Excel – and I’ve appended some Excel columns with some comments which I have to keep local on an Excel file and can’t go into the original SP list. This works ok except when the SP list columns in Excel are sorted and then refreshed – which leads to...

Hi, I'm trying to import some data from the web using data connections and I keep getting this error: "Unable to connect. We encountered an error while trying to connect. Details: "External table is not in the expected format."" The link I'm trying to connect with is...

I am using ETL Manager extract URL as an external connection (from Web) in Excel. However that always gives me a top row with cell A1 saying "DSS Report". I would like to get rid of that row so I tried to use the ETL URL as a data source for Power Query. When I go New Query -> From Other...

I am trying to use a .atomsvc file from an SSRS report as my external data connection in power pivot. Every time I tried to connect to this particular report I get an error message: Invalid URI: the Uri string is too long. Anyone know what this means? Is there any way I can get around this...

So I have a document that has a pivot table that was previously linked to an access query. It worked fine, no issues. The problem started when I wanted to change which database the pivot table was linked to. When I tried to change the external data source to the new database, excel gave me the...

Hi All, I need to insert barcodes into an existing excel macro, however this issue I have is the company I work for won't put any excel barcode softare on the PC's for us to use. Is there a way I can somehow link it to an external free barcode website e.g. Barcode-generator.org or...

Dearest Excel Magicians, Wizards and Gods I have a report that was made some time ago (P&L report). It grew to 60mb at this point, and with all the pivots, caluclations etc - well, it got very obese, slow and lazy. I figured out, that I will move all the source data to MS Access database. But...

Hi- I am creating external data connections to multiple excel files within my server. When I bring this data over in a table format some of the data comes over as numbers and some as text. I need all the data to be formatted as numbers so I can run formulas off these tables. I can't even...

Hello, I have written some VBA code (below) that sets up an external data connection in a workbook, queries a stored SQL procedure on an external server and imports the resulting recordset into a QueryTable. However, I have a stored procedure saved on a server that contains two select...