Forum Discussion
Solved
Use a named range in Excel for Power Query Data Source
My client needs txt files from a supplier converted to excel. I've created a PQ to do that but I'd like to make life easy for them so I've added some VBA which allows them to look up the file to b...
Hi everyone
A dirty solution would be to ignore the privacy levels.
The procedure is described here:
https://exceloffthegrid.com/formula-firewall-in-power-query/#AlwaysIgnore
THAT'S IT!!!!
Thank you! it's been driving me mad!