+ Reply to Thread
Results 1 to 3 of 3

Microsoft power query for excel

  1. #1
    Registered User
    Join Date
    04-17-2017
    Location
    Mexico
    MS-Off Ver
    2016
    Posts
    48

    Microsoft power query for excel

    I would like to know about Power Query, I'm planning to install it and I would like to know certain things about it if is possible.

    What do you think of Power Query is it helpful?

    Is it free?

    Can I use it in and if I sent the file to someone that doesn't have it, could him work with the file perfectly?

    If you have extra information, please tell me.

    Regards!

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Microsoft power query for excel

    If you have Excel 2016 it comes as standard feature. But it's called "Get & Transform" and found under Data ribbon tab.

    If you have Excel 2010, it's free add-in.

    If you have Excel 2013, you need specific license SKU (ProPlus, Standalone Excel, Enterprise 3 etc).

    Can I use it in and if I sent the file to someone that doesn't have it, could him work with the file perfectly?
    Unfortunately no. They won't be able to edit Query (and I believe they won't be able to refresh query either). However, if you load the data to worksheet and kill connection. They won't have issue with it.

  3. #3
    Registered User
    Join Date
    04-17-2017
    Location
    Mexico
    MS-Off Ver
    2016
    Posts
    48

    Re: Microsoft power query for excel

    I was asking for an installation of it to mi system department, until I see your message, I have excel 2016,

    Thank you so much.

+ 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. error in power query & power pivot
    By Baldev Kumar in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-03-2018, 01:34 AM
  2. [SOLVED] power query on os xp with excel 2010
    By JEAN1972 in forum Excel General
    Replies: 3
    Last Post: 04-02-2017, 10:39 AM
  3. Excel 2010 Power Query from folder with CSV
    By davidbrennan in forum Excel General
    Replies: 0
    Last Post: 03-22-2017, 09:56 AM
  4. Excel Power Query - Can it do what I need?
    By Spiros in forum Excel General
    Replies: 2
    Last Post: 08-24-2016, 11:23 AM
  5. Excel Crash when trying to use Power Query
    By Bikashmittle in forum Office 365
    Replies: 2
    Last Post: 02-03-2016, 11:22 AM
  6. Importing Access query into Excel:Microsoft Query
    By ge0rge in forum Excel General
    Replies: 3
    Last Post: 04-02-2009, 10:51 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