Sep 19 2023
Has anyone managed to get power query on mac working to load excel files from folders & sub folders?
By following this for the main folder https://www.mrexcel.com/excel-tips/power-query-debuts-for-excel-for-mac-but-with-significant-gaps/
I'm halfway there but have hit a prob on the files that are stored in sub folders.
It brings them back but doesn't ref them correctly (path is that of the parent folder) and so data load fails..
Thanks in advance