Forum

Thanks for your reply, Anders. I get that and I do exactly that where possible. In this case it isn't and my underlying question is simply: how to s...

Hy Mynda, Great advice - many thanks. Pieter

Hi Mynda, That's absolutely great - thank you so much. I'm really enjoying my PQ course and hadn't quite got to this stage yet. You were quite ri...

Hi Mynda, Good morning - for you. early evening here. I fully agree with your suggestion for the Mac tester; it was one of my politer thoughts,...

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...