data connection

  1. N

    Data Connections and Workbook Links

    I am creating links between 2 excel workbooks. When I open one workbook, there supposed to be a popup message as below for me to decide whether to update or don't update the links from the close workbook: In Trust Center, already checked "Prompt user about Data Connections" for Security...
  2. K

    Excel Datamodel refers to orignal file data when saving as new file.

    My workbook contains 2 different tables of data (table1 andtable2) both data tables have a column named “Product” and from each data tableI have created a pivot table (pivottable1 and pivottable2) In order for me to be able to use one single slicer toselect/filter the same value in both pivot...
  3. N

    Excel Web Data Connect with Username and Password

    Hello, I know this has been asked, because I have found prior threads. But hence my username, I'm pretty helpless when it comes to web data connections, especially password protected ones. I would like to do a web connect for a power query on fantasy football data. Here is the website...
  4. S

    Looping through sheets while setting up different data connection for each sheet

    Greetings Outstanding Mr. Excel Community, :) I have some experience with using Excel macros and VBA scripting but I don't know enough about loops and arrays to solve this little problem. I think I have just about all the code correct, so this should be an easy fix. Basically I have a workbook...
  5. C

    Refreshing Data Connection changing forumlas issue??

    Hello, I've recently run into an issue where the formulas in my summary tab are being changed when I refresh my data connection. Has anyone seen this before? Or know how to trouble shoot? To give some context there are two formulas below. When I refresh the data connection the $R:$R changes to...
  6. O

    VBA Data Connection refresh opens up relevant workbook if in use - Please Help?

    Context: I have been creating a dashboard to show a summary of various other workbooks. To do this I have setup data connections, which at the beginning of my macro are all refreshed using, Refresh All. The issue: If one or more of the workbooks, for which the data on my spreadsheet is...
  7. S

    Excel Data connection

    Hello I've created date connection to my sheet which simply an existing excel file. I need to modify that file to get the updated records in my sheet. The problem that i need to close my sheet before i modify the existing excel file. Is there a way to modify the source (The data connection file)...
  8. M

    Refreshable Data Connection from Web to Excel TABLE

    The end goal is to have an Excel Table with a refreshable data connection to a web table. The reason to have an Excel Table is to use that Table as a reference point on other sheets, to perform calculations on other sheets, and to create summaries on other sheets. All of this is made much...
  9. J

    VBA - Create Data Connection when CommandText is Too Long

    Hi, Usually, I use below VBA to create Data Connection with SQL database to extract data through MS Query. And it works perfectly fine. As defined, SQL_CommandText is a string where you can set your SQL. However, I get a huge SQL that is around 16,000 rows (40,000 characters). This VBA code...
  10. S

    Hyperlink question

    Hello, I have created a hyperlink on my spreadsheet with CONCATENATE, and it opens the file from my server just fine. It resides in G4. In H4, however, I would like to have a formula that pulls a value from that hyperlink in G4. I have this formula: ='[G4]2-4-16'!$I$4, but Excel still makes me...
  11. T

    Programmatically change connection string for excel source file for power pivot

    I have been struggling so long with this and I'm really in dispair since my last finding was that not all connection types can be updated. I have a PowerPivot that sources the data from another Excel file. I want to be able to send this PowerPivot file to a number of users and they should all...
  12. M

    Only partial data obtained from connection with Access 2007

    Hi, I have a data connection in Excel 2007 linked with an Access 2007 file. On my computer it works fine but on my colleagues computer it doesn't quite work. When he opens and updates the file, the linked table deletes some data. In the table once it gets past 13/08/2015 it does not produce...
  13. H

    2 Data Connections, 1 Table

    Hi, Quite a specific question, might even just be a 1 word answer (if it is, hopefully it's "no", as just answering "Yes" won't be that helpful)..... So currently I run 3 reports from 3 different systems that don't talk to each other. Previously, I would take the output from each and combine...
  14. B

    Excel 2010 Data Connection - Add Filter to Command Text

    Two relevant workbooks (sitting in the same shared drive): Historical Data.xlsx: with a table GLDATA, which includes a field cc Template.xlsx: with a named range COSTCENTER Question: How do I modify the Command Text in the Data Connections Properties dialog box (using either SQL or Table...
  15. G

    Questions about implementing a data connection

    I am new to data connections, and while it is working, it's not behaving as I expected. I have a form where the user enters an Order Number, and based on that value, I retrieve the Product Code, Lot Number and Product Description. I have established a data connection to an i5 server. I used the...
  16. M

    Automatically Insert Daily Forex Data in Excel

    Hi everyone, I'm in the process of building a huge forex database in excel for my own analysis purposes. I have collected the past 30 years forex data for top four currency pairs! I would also like to keep the database up-to-date with daily forex information such as, opening, closing, high, low...
  17. R

    Multiple workbooks refresh from password-protected database. How to enter pwd/login just once?

    Hello, Our organization has about fifty scorecards in Excel, with three data connections apiece. All of them refresh from the same password-protected database. Is there a way to write a script that will open and refresh all the workbooks at once, wihtout having to type the login and password...
  18. S

    VLOOKUP to Data Connection not working

    Hi, What I need to do: I have two files, File A: A master spreadsheet that is updated regularly and File B: a consumer facing spreadsheet that needs to be connected to File A and updated whenever File A is changed. As far as I got: I created a data connection between File A and B so that File...
  19. A

    SQL data connection in Excel - update SQL tables using table in Excel

    I created a SQL query that gathers information for users to determine which items in our system need to be inactivated. The user receives an Excel workbook that has a table with a data connection to the SQL Server database that pulls in the information they need (via stored proc). I want to...
  20. D

    Proprietary Info and Caching of External Data

    I've read over these threads for quite a few years now and have almost always found any answers I needed, or at least got pointed in the right direction. Unfortunately, I need to ask for your expertise. I am using Excel 2007. I put together an Estimate sheet that pulls date from a Master sheet...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top