Hello,
I recently created a series of VBA macros on excel for windows. It uses power query to sort and compile data from multiple sources (within the same excel file); it works across multiple iterations of excel for windows.
I am trying to get the same file to work on excel for mac, version 16.35 to be exact. I have identified which macro is not working, and it is the one that refreshes the power query. I am wondering if power query works for mac when it is compiling data from tables/ranges within the same excel file, or if that functionality does not exist yet and I am barking up the wrong tree. Does anybody have experience with this issue?
Thank you
Bookmarks