How to make Power Query refresh on an Excel protected sheet

Опубликовано: 09 Февраль 2025
на канале: Celia Alves - Solve & Excel

16,614

111

Power Query does not offer the possibility to refresh queries that load to tables in protected sheets to be refreshed while the sheet is protected. A simple macro will do the trick, but there is a very simple detail that we must not forget, or the macro will not work.

More on how to make VBA wait for Power Query here:
https://solveandexcel.ca/2023/06/23/h...

Learn how to automate your Excel Retorts: https://snapreportschamp.com/course

---------------------
Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Facebook:   / solveandexcel
Instagram: @solveandexcel
LinkedIn:   / celiajordaoalves
LinkedIn:   / solveandexcel
Twitter: @celia_excel
Solve & Excel Consulting - https://solveandexcel.ca/
-------------------------
#Excel #solveandexcel #microsoft365 #toronto #torontobusiness #wit #msexcel #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #canada