Forum Discussion
Custom view when opening a protected workbook
Our purchasing department maintains a locked workbook which multiple departments use for ordering information. The data in the cells is controlled and updated by purchasing, but everyone accesses the...
Hi Kimberly,
If you have Excel 2010, 2013 or 2016 then you can use Power Query to connect to the master file and have you're own "view" of the data. (filtered / sorted) . With Excel 2013 and 2016 you can also add "Slicers" to tables to make them really easy to filter.
Let me know what version of Excel you are using and if you have used Power Query in the past