Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.