I`ve noticed after unlocking some columns in sheet 1 (Data), and protecting the Data sheet, that my pivot table in sheet 2 (Analyze) being fed from the Data sheet, no longer works, is this correct? (It appears that partially protected sheets stop pivot tables from calculating data?)
And the table in sheet 1 (Data) no longer populates down the page once its rows are full.
I want to protect my; day, week, month, year, GST, and subtotal columns from being editable.
But when I do protect those cells, the pivot table stops working.
I also find after unprotecting the worksheet 1 (Data), the data table on sheet 1 no longer elongates downward when dragged.
It seems protecting sheets breaks both data tables and pivot tables?