I want to create a pivot table from an external data source which is a protected (for opening) excel sheet. The reason for creating the pivot table is to allow users to access certain information from the data source and protect the rest. How do I do create the pivot table? When I choose 'exeternal data source' and choose the protected workbook, I get a 'data link properties' window and if i press 'ok', i get a 'data source is not vaild' message. This happens only when the data source workbook is protected.
Anybody know how to get around this issue?

Thank you!