This is great news from Microsoft Excel Team!!!
Hats off to the team for making this important change.
This is great news from Microsoft Excel Team!!!
Hats off to the team for making this important change.
Here's a useful link posted by Hui on the Chandoo forums: https://app.powerbi.com/view?r=eyJrI...MiOjEwfQ%3D%3D
It takes you to a list of feature requests regarding Power Query, all in one place.
EDIT: The link seems not to be working today - it was yesterday. I'll leave it, though, as if it's fixed, it may prove useful to some.
Last edited by AliGW; 05-23-2018 at 01:20 AM.
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.
The link seems to work- you just need to click on the button afterwards (not sure why).
Don
Please remember to mark your thread 'Solved' when appropriate.
You probably have not read the small print.
There are different versions of office products with different features. It is highly unlikely MS will treat all its different class of customers the same.
Have you also noticed the size of office 365 is almost 1GB now? By the look of MS' constant update, it will hit 2GB soon.
I had to wait for 2 hours for update. Since Windows 10, we have lost control of MS' botched update.
No one except MS knows with our harvested data.
It clearly states all Windows SKUs. Not great for Mac users, but everyone else with 2016 or later gets it.
So does anyone know how to get the update?
I just updated Home and Student 2013.
After restarting it's still not on the ribbon or in Options > Add-ins.
No links enlighten me. What am I missing?
Dave
It is from build 9330 onwards - my Office 365 is up-to-date, but not yet on that build, so it’s a case of waiting until we are. I’m not on the insider programme.
Ali,
Thank you. I'll keep an eye out.
Dave
It's not coming to any new 2013 or non-subscription 2016 SKUs. If you have one of those and don't already have Power Pivot, you're still out of luck.
Build 9330 is now available for Office 365 and the Manage Data Model (PowerPivot) icon now appears on the ribbon. Now to try using it!
Found download here today.
https://www.microsoft.com/en-us/down....aspx?id=39379
Under System Requirements it states:
Microsoft Power Query for Excel requires Internet Explorer 9 or greater.
Dave, you've win10 so probably you've IE11 also (whatever but for sure higher than 9)
Thanks sandy. But I have Firefox and want to keep it.
Anyway I finally "threw in the towel" and upgraded Office 365 this evening. I wanted the new functions, too. I'm delighted to find they didn't over write my Custom Lists, QAT or other settings. Excel loads as I left it in 2013. Yay.
Dave, now you'll be Excel Wizard, LOL
Dave - you don't have to use Edge (or IE) - it just needs to be on your PC, which it will be along with Windows 10, as Sandy pointed out. I have Firefox and Microsoft haven't prevented me from using it since the PowerPivot functionality appeared in the 365 version of Excel.
I don't think you'll regret the move to the subscription model.
Thank you Ali. I was a little bit 'on edge' about the move anyway. Really wanted the new functions and PP/Get and Transform. I finally "caved in" and made the move instead of going the add in route.
I resisted it for such a long time, also dubious about it, but I have never looked back. OneDrive is another thing that is really worth having.
OneDrive (with different names) exist from [edit:]2007. This is not new feature
Last edited by sandy666; 06-18-2018 at 02:18 AM. Reason: see edit
I didn't say it was, did I? I said it was worth having. In any case, the older versions were not great: it has improved significantly over the past two or three years.
whatever you say
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks