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.