+ Reply to Thread
Results 1 to 6 of 6

Powerquery working for me but not others

  1. 02-16-2021, 01:13 PM #1
    Izzii0x
    Izzii0x is offline
    Registered User
    Join Date
    11-27-2017
    Location
    Surrey, England
    MS-Off Ver
    Office 365
    Posts
    65

    Powerquery working for me but not others

    Hi all,

    I've attached a sheet with dummy data that I have produced some powerquery tables for and therefore some charts associated with it.

    I've tested this on my windows and my MAC and both work perfectly, but when the person I am sending it to tries, they click refresh data and nothing happens. They sent me a video so I can see they are doing it after selecting enable content etc - but their version of Excel (MAC) looks a little more dated than mine - could that be the reason? I am using the latest Office but theirs looks to be 2011.

    If that is the case, is there anything I can do to make it friendly for 2011 users?

    Many thanks
    Izzie
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-16-2021, 01:15 PM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,432

    Re: Powerquery working for me but not others

    It certainly WON'T work on Mac 2011. Good to know that the Mac 365 version finally supports PQ, though.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 02-16-2021, 01:56 PM #3
    Izzii0x
    Izzii0x is offline
    Registered User
    Join Date
    11-27-2017
    Location
    Surrey, England
    MS-Off Ver
    Office 365
    Posts
    65

    Re: Powerquery working for me but not others

    Would it work on Excel 2011 Windows? As he said he also sent it to his friend with windows and they had the same issue.

    Bumping into so many issues when it comes to transferring Excel workbooks to Mac - wish they'd sort out the functionality, already.
    Reply With QuoteRegister To Reply
  4. 02-16-2021, 02:01 PM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,432

    Re: Powerquery working for me but not others

    There was no such version for Windows.

    Power Query is available as an add-in for Excel 2010 and 2013: https://www.microsoft.com/en-gb/down....aspx?id=39379

    It is part of Excel 2016 and above.

    It will not work at all on versions earlier than Excel 2010 for Windows.
    Reply With QuoteRegister To Reply
  5. 02-19-2021, 03:37 AM #5
    Izzii0x
    Izzii0x is offline
    Registered User
    Join Date
    11-27-2017
    Location
    Surrey, England
    MS-Off Ver
    Office 365
    Posts
    65

    Re: Powerquery working for me but not others

    Thanks so much for your help
    Reply With QuoteRegister To Reply
  6. 02-19-2021, 03:49 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,432

    Re: Powerquery working for me but not others

    Sorry it wasn't better news.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. PowerQuery index match prioritized criteria from 2 columns
    By Imbizile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2020, 08:52 AM
  2. PowerQuery
    By wherdzik in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-08-2020, 03:03 PM
  3. PowerQuery in Excel: Use an Excel table to populate SQL table in PowerQuery
    By joeyslaptop in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-25-2019, 02:33 PM
  4. PowerQuery Many 2 Many Relationships
    By rabbit_post in forum Excel General
    Replies: 1
    Last Post: 02-01-2018, 05:17 PM
  5. VBA vs PowerQuery
    By Trachr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2017, 11:50 PM
  6. PowerQuery and VBA
    By Trachr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2017, 12:10 AM
  7. Help with powerquery.
    By stephme55 in forum Excel General
    Replies: 0
    Last Post: 09-01-2016, 07:31 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1