I have an Excel workbook with eight data connections to various SQL Server data sources, most of them stored procedures that return tables of data. The connections are set to refresh either when the workbook is opened or automatically when the contents of the cells that contain the SP parameters change.

Right now, if someone lacks the security access to view the data, the procedures come back empty and the user doesn't see any data....