i hv created a pivot table and set 'ShowPages Entity = Division' so that all pages will be separated into a separate workbook.

i hv the Division field as the page field, with Divisions 1, 2, 3, 4 and 5.

however my problem now is that after each page is in its own workbook, the user is still able to change the page field to that of other pages. for example, i have 5 workbooks, each containing the data from each Division. however the user can easily change the page field on the wb which holds the data of Div 1 to Div 2 and view the records from Div 2.

is there any way to disallow the user to change the page field at each wb holding data from Div 1,2,3,4,5 respectively??