8/31/2023 0 Comments Power query excel mac 2019I asked him to use Power Query to combine different sheets, but then I realized that for someone new to Power Query, doing this can be tough. Question from me: Can Microsoft provide an update on this? Where do you stand now.I recently got a question from a reader about combining multiple worksheets in the same workbook into one single worksheet. As you can understand, this is an expensive project and we adopted a staged delivery plan - we aim to release valuable functionality to the users as soon as we are done with coding and testing" Also providing feedback saying that "the goal is to support full query authoring on Mac. See below couple of things I was able to find on Hunkin, Program Manager at Microsoft writes an article in October 2019 about the introduction of the ability of refreshing existing queries in Excel for MacOS. Any workarounds available to avoid having to have a Windows OS to be needed?. Can Microsoft provide transparancy regarding their roadmap? What can we expect by when - and what not?.Hoping I can get more details on things such as: Seeing as this was stated somewhere in 2019 it does make me curious to understand where Microsoft stands now in regards to further rolling out this functionality for MacOS. Looking at the amount of users voted for getting this feature fully supported on MacOS I am confident this is something that is continuously being worked on by Microsoft. Spending a week on researching the internet learned this functionality is not - yet - available for MacOS.įrom what I have been able to learn, the newest Excel 365 does offer the option to refresh existing queries - queries created on a Windows machine, though also learned according to Microsoft this is rather "phase 1" and we should expect more to come. More or less immediately ran into issues when trying to find the Get & Transform functionality on the MacOS - it simply was not there. Recently switched over from Windows to MacOS, not knowing the versions of Excel 365 for both the OSes are not the same.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |