data connections

Name code Size in cm Weight in kg Age Gender M/f kg/cm size/age weight/age Persons Andrew Black P001 180 82 23 M 0.46 7.83 3.57 Sarah Jones P002 169 71 32 F 0.42 5.28 2.22 Tim Bradford P003 175 71 45 M 0.41 3.89 1.58 Julie Clark P004 172...

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 exporting 2 lists from SharePoint, then running formulas involving fields from both sheets to create reporting, etc. I'm then refreshing the tables in excel to update the data, so the connection needs to stay intact. I'm also using PowerPivot to create a data model to work from with many...

Hello, I only started using PowerPivot after Power Query was readily available. I come across example Excel/PowerPivot documents where the data is embedded into the Data Model and I don't understand how you can modify the connections. I found this cool PowerPivot example here on the forum...

What I have is one Workbook serving as a Data Entry form. That form populates another Workbook that serves as a Database. From that database, I have a third Workbook that I have data connections in back to the database to analyze the data in different ways (Pivot Charts, etc.) The problem I...

Normally I search a long time before posting but I have to get to a meeting and if I cannot get this answered now (4pm EST on a Friday afternoon), I cannot finish work planned for this weekend. I would DEEPLY appreciate any help! The research I've found looks like there is no solution from...

Hi, I work with someone who installed the new excel 2016. For some reason when he clicks ‘data connections’ under the ‘data’ tab it shows up as a side panel instead of a box. We have found this to be difficult to use and limiting as there doesn’t seem to be a way to add new connections in a...

I am using the below Select statement, which works fine. However, when I change the values below in Red to ? as is done in the WHERE clause toward the end of the statement in order to use parameters defined in specific cells in a worksheet, I get a "Numeric Value Out of Range" error. I do not...

This one is starting to hurt my brain. I have a workbook with multiple sheets and the point of the book as a template for a questioner/form. Each tab has various items to fill out or answer. Some basic info, some with dropdowns, and some referenced via formulas. Each client will have their own...

I have a set of separate workbooks that all live in the same folder and reference data within each other. Basically they are a header table and then several detail tables and are used to record inspection data at each of the machining operations in our machine shop. When we machine a new batch...

Greetings, I am looking for some excel help with connecting, filtering and using a website API. I have an example of what I am doing by hand and I am looking to automate the process as much as I can. Right now I have a row with airport codes along the top, I then have a row going down...

Hi guys, I have an excel workbook that I need to manually update monthly. I have a drop down menu with multiple variables, so I need to go through every possible combination of the data. For each combination, the data values are updated from external data connections. I have tried to record a...

I have an excel file that has numerous data connections to a database. How can easily edit the connection string to change the file name of the copied database? I need multiple sets of excel and access files to accommodate multiple users. Excel Template - Database Excel Template 2 - Database 2...

Good day, For our next project we would like to use a master excel file (monitoring dashboard) that brings together all the information stored in 4 individual excel files in a cloud. The 4 individual excel users should not see the master file (as they should not see each others work) but I...

I've come across a problem that no amount of googling is helping me with. While refreshing workbooks with pivots (that are externally linked to another excel file containing the data) using VBA ( .RefreshAll), a dialog box titled "Data Link Properties" pops up. I've tried to suppress the dialog...

Hi all, i am creating data connections between excel files in order to import tables of data from one file to the next. I have been successful so far at importing and refreshing such imported tables. however, one of my source tables is quite large and i do not need all of the fields each time...

Within Excel I have multiple Data Connections; all configured the same to retrieve similar information from similar webpages. They all work on the day and download the information in the correctly specified format [Formatting=None] however, the next day, I go back to run the Data Connections...

I have a template with formulas in column I and J. When the user makes a data connection inside the template, it brings data into columns A thru H. My formulas are being cleared out in the cells below the row brought in. Example they make a connection to an excel file that has 200 rows. When the...

Hi, I'm working on a Macro that is working intermittently to change the Command Text in a Stored Proc connection property. e.g. exec dbo.usp_ShepherdBonusDataBreakdown 'Sonya Taylor',7,2013 Changes to [SurveyorName] based upon 'Variables' Range "E4" With Workbooks("Surveyor Statement...

I'm using 2007 Excel and Access. I've got a pivot table linked directly to a MS Access database. The table is large around 400K records. First refresh-The initial pivot refresh takes it's time refreshing the data, then relatively quickly will update the fields. Second refresh-After the...