+ Reply to Thread
Results 1 to 4 of 4

Work in connections with external data

  1. #1
    Registered User
    Join Date
    06-27-2016
    Location
    ontario canada
    MS-Off Ver
    2013
    Posts
    2

    Work in connections with external data

    Hi guys, I have a presentation about "work in connections with external data" and I have no idea where to start. Is there any way you guys could provide me with simple instruction on what to focus on? Thanks guys!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,964

    Re: Work in connections with external data

    Define what you mean by "work in connections with external data", just so we are all on the same page?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Work in connections with external data

    Hi,

    The newer Excel tool called Power Query or Get & Transform Data might be the topic you need to study. Excel deals with lots of external types of data using this newer tool. Power Query is an Add In in 2010 and 2013 and built into 2016. Search on Power Query.
    https://support.office.com/en-us/art...8-b68e9e616f5a
    https://support.office.com/en-us/art...0-9d4679be4961
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    06-27-2016
    Location
    ontario canada
    MS-Off Ver
    2013
    Posts
    2

    Re: Work in connections with external data

    Thanks MarvinP I know where to start now! Thanks guys!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 05-14-2015, 05:16 AM
  2. external data connections are not refreshing even with VBA
    By krishna2221 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2014, 04:00 AM
  3. Replies: 0
    Last Post: 08-20-2013, 10:08 AM
  4. When are External Connections not QueryTables?
    By apolloni in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2013, 08:11 AM
  5. external data - cleanup existing connections
    By edstevens in forum Excel General
    Replies: 1
    Last Post: 04-26-2013, 12:03 PM
  6. Replies: 2
    Last Post: 05-24-2012, 08:43 AM
  7. Pulling Data from unopened Excel Spreadsheets with external connections
    By nschneemann in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2010, 11:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1