ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to disable data source- pivot tables (https://www.excelbanter.com/excel-discussion-misc-queries/234700-how-disable-data-source-pivot-tables.html)

Dummy

How to disable data source- pivot tables
 
I would like to disable users from having the ability to change the data
source or connection in Excel 2007. Is there a setting somewhere that would
'dim' out the accessibility to users? In Excel 2003 the user had to know
what they were doing to even access the source so we had no issue, but not so
in Excel 2007 as this front and center.

Thanks


All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com