I have created a Pivot Query table using merge function for reporting purpose. The idea is that all entries would be done through first sheet which would get reflected to the second sheet (for reporting), but second sheet couldn't be edited. However, while using lock and protection, refresh would not reflect any changes made in first sheet. Is there a way to implement the idea in excel?
