How to set the number of display rows to unlimited?

The MOSS 2007 Excel services' report only display ~70 rows at a time.

Is there any way to display all rows at once (about 120 rows)

Regards,




Answer this question

How to set the number of display rows to unlimited?

  • David McGraw

    Thank you very much. I will try it.

    Regards,



  • Adysoft

    You can control this in the Modify Web Part properties - it's one of them under the View section (I think).

    You cannot have it as unlimited, but you should be able to set it to 120. There's a limitation of returning 10,000 cells at a given time from Excel Services (IIRC).



  • MaggieChan

    Can anyone give me more detailed explanation how to set up this in SharePoint

    Thanks.

    Aleksandra


  • David N.4117

    Aleksandra,

    Can you post a seperate thread with specific details on what you are trying to set up.

    Andrew



  • How to set the number of display rows to unlimited?