Forum Discussion
Solved
Missing get and transform data
hi all, i am new to excel and id like to add an api to one of my sheets, however even tho i have 2016 excel version there is no get and transform data for me which is what id really need. c...
I'm not familiar with consumer versions. In general on subscription model ( Microsoft 365 ) you always have the latest functionality compare to similar perpetual version. The latest has fixed functionality and updating only bug fixes and security patches.
On Microsoft 365 set of features depends on subscription level and distribution channel. Enterprise has the richest functionality, other levels we have to check.
Distribution channel means how often functionality is updated. On insider (beta) channel you have updates every week, on semi-annual channel - twice per year. Good news you may shift from one channel to another at any time, that's free of charge.
As for Power Query on Personal - most probably it's available, but I'd double check. You may install trial version (one month as I remember), check if that's what you need and only after that pay for the subscription.
i'M USING oFFOCE 10 BUILD 19042 ON A pc. MY LATEST WORKSHEET DOESNB'T SHOW THE CELL THE CURSON IS IN AND i CAN'T FIND A FIX. hOW DO i HIHGLIGHT HTE CELL MY CURSOR IS POINTING TO?