Ask a questionAsk a question
 

QuestionLimitation of 'Excel Services' in Sharepoint

  • Friday, October 23, 2009 12:36 PMRevathy Menon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    Hi,


    For the following 3 scenarios, I have given the limitation of 'Excel spreadsheet' and I would like to know the limitation of  'Excel Services', when publish in Sharepoint.
    Case 1:

       If a column in Excel sheet has more than 70000 records, and I am using it as  ‘Report filter’ column in ‘Pivot table’, then when I click the drop down button, I can see only 65533 records.

    I am not sure how many values it will show If I publish it in Excel Services of SP?

    Case 2:

    If   I connect a DB with Excel and populate a column which has 70000 records, and I am using it as  ‘Report filter’ column in ‘Pivot table’,  then when I click the drop down button, I can see only 65533 records.

    I am not sure how many values it will show If I publish it in Excel Services of SP?

    Case 3:

    If   I connect a SSAS Cube with Excel and populate a column which has 70000 records, and I am using it as  ‘Report filter’ column in ‘Pivot table’,  then when I click the drop down button, I can see only 32000 records.

    I am not sure how many values it will show If I publish it in Excel Services of SP?

                              If any of you guys share some points in the mentioned questions, it would be more helpful.