Fred Stimler

Fred Stimler

  • NA
  • 1
  • 641

Excel Browser in SharePoint 2013 not allowing parameters

Aug 10 2015 2:27 PM

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.