0
Answer

Excel Browser in SharePoint 2013 not allowing parameters

Fred Stimler

Fred Stimler

9y
356
1

The Excel Browser in SharePoint 2013 will not allow me to view a spreadsheet where I pass 7 parameters to a SQL Stored Procedure (to filter 1.7 million records). I am using Excel 2010.  The message is a confusing note on parameters and pivot tables.  Is this a setup issue in SharePoint or do I have to re-engineer the Excel spreadsheet?  We are posting Power View reports, Excel w/PowerPivot and others in this same gallery.  Thanks.