How to fix the Formula Firewall in Power Query | Excel Off The Grid

Описание: ★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy


★ Check out the blog post★
https://exceloffthegrid.com/formula-f...


★ About this video ★
One of the most frustrating error messages in Excel is the Formula.Firewall error. It only ever comes when we try to do something advanced, and the message doesn't make any sense!

In this video, we show you why the Formula Firewall is there (it's actually there to help us!) and how to work with it within Power Query

0:00 Introduction
0:27 What is the Formula Firewall?
3:15 Scenario
4:18 Flattening queries
7:15 Apply privacy levels
9:36 What are privacy levels?
10:48 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/


★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com


Twitter:   / exceloffthegrid  


#MsExcel