Custom Views conflicts

After singing the praises of Custom Views all through this chapter, I now have some sad news to deliver. The Custom Views feature is unavailable any time that you use the Table feature, which I sang the praises of in Chapter 7, Automating Tasks with the Table Feature. A conflict can sometimes arise with the Power Query feature, which I will discuss in Chapter 12, Power Query. Older versions of Excel for macOS permitted users to use Custom Views and the Table feature together in the same workbook, but the Windows version never has. This means you will sometimes have to choose between which feature (Custom Views, Table, or Power Query) will offer the biggest most effective automation and data integrity in each a given workbook. In addition, the Review | Protect Sheet and Review | Protect Workbook commands can also sometimes pose conflicts with Custom Views.

Nuance

Power Query only disables Custom Views when results are returned to a Table. This means that...