Hi Mynda, Apologies - I conflated two issues. The error message I referred to was when my Mac tester ran the queries "as-is" with my original path...
Hi Mynda, I've heard back from the Microsoft Excel team [same link] and it seems that "...the Privacy Settings for all data sources on Mac are set ...
Thanks - I've sent the folder to Guy Hunkin but haven't heard back yet. I'll let you know any outcome. Pieter
Thanks Mynda, Sorry - I didn't mean to embarrass you by cross-posting; TBH, it only occurred to me late in the day and I told you at our next excha...
Another thought: perhaps I could use VBA to modify the query source directly, instead of passing it as a parameter? Pieter
Hi Mynda, Thanks - I appreciate that. I've also posted on Technet (Guy Hunkin) to see if there's an answer there. The Mac message doesn't say F...
Hi Mynda, Yes, I've tried it with several other PC users and it works fine with them - it's just Mac users with Excel /Office 365, so it looks like...
Hi Mynda, Welll, I thought I'd done exactly that! The lesson describes what can happen when, say, merging a table with an external source, but I d...
Hi Mynda, It's taken me a bit of time to link with my Mac-using tester but I finally have a clearer picture of what's happening. I hestitated to p...
Hi Mynda, Thanks for the suggestion and I'll try hard coding the query as you suggest instead of using a parameter table, though it'll severely lim...
Hi Alan, Thanks for a brilliant and detailed post that's gone a long way to helping me understand what I want to do - and you've summarized it perf...
Hi Mynda, Thanks - I was about to go down a rabbit hole and you pulled me back from the brink. I was using Get Data etc as a (misguided) diagnosti...
Hi Mynda, Sorry to have to come back on this one. My Mac-using colleague says he can't reference the .XLSX file. I directed him to Data / Get Dat...
Hi Mynda, Your hint was invaluable and got me a long way down the path. I had a filter on the original data, driven by a selectable value in a par...