Hello Everyone:
I have a dilemma. I work in Excel 365 for Windows and my client works in Excel for Mac. Not sure which version they have.
I have started using Power Query in their workbooks, to save time programming and with formulas.
The issue is that the queries are not work on their end. From what I have read, the Power Query must be separated from the workbook, which I must send to them separately, and then they link the workbook with the query?
But, I am not quite sure how to do that. Complicating further, they store all of their files on Dropbox. I have had trouble in the past with data connections on Dropbox, due to file paths. (For example, My computer vs their Dropbox folders)
I have been looking for step by step process to:
--Export my Query (don't see an option for that)
--Put the Data File and the Query in same folder in Dropbox?
--How to link the data file to the query on the Mac. I do not have a Mac.
If anyone has experience with this and can offer some advice, I would appreciate it!
Bookmarks