Skip to Content
author's profile photo
Former Member

Unable to Refresh Webi on (direct) Excel having 5000+ rows

Hi

Please suggest on the following...

Issue:

Unable to Refresh Webi on (direct) Excel when excel no. of rows is more than 5000 rows of data. (upto 5000 rows works fine)

Error Message is: "Unable to create or update the Excel personal data provider: the range selection is invalid. (WIS 10885)"

Observations:

- The size of the excel file does not seem to matter as adding 1 row more will not increase excel size significantly.

- I was looking for "Max rows retrieved" in Webi Rich client User Guide but no such setting can be set when webi is on excel.

Thanks

Deep

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Apr 07, 2011 at 09:50 AM

    Hai Deep,

    This error is due to the cell range in excel file is invalid

    To rectify this you can verify the excel file or BO administrator.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 26, 2011 at 04:43 PM

    Hi,

    As it is mentioned in the note 1356508 :

    Ensure that each cell of the first row contains text as these are passed on to Web Intelligence as Column Names.

    Regards,

    Anil Kumar Sharma .P

    Add comment
    10|10000 characters needed characters exceeded