topic Is there any limit for Excel get Worksheet as a range action? in Product Forum https://community.blueprism.com/t5/Product-Forum/Is-there-any-limit-for-Excel-get-Worksheet-as-a-range-action/m-p/65309#M17926 Hi All,   I have an Excel sheet where i'm performing some refresh operation with Power queries. After performing refresh i am reading the entire sheet as collection. My Excel sheet may contain data over 5000 rows. while performing this step BP is getting hanged. Is there any range limit for BP to collect from Excel?    Please guide me if you have faced this issue.   Thanks in advance   Fri, 11 Jan 2019 18:17:00 GMT sai_bhargavaraj 2019-01-11T18:17:00Z Is there any limit for Excel get Worksheet as a range action? https://community.blueprism.com/t5/Product-Forum/Is-there-any-limit-for-Excel-get-Worksheet-as-a-range-action/m-p/65309#M17926 Hi All,   I have an Excel sheet where i'm performing some refresh operation with Power queries. After performing refresh i am reading the entire sheet as collection. My Excel sheet may contain data over 5000 rows. while performing this step BP is getting hanged. Is there any range limit for BP to collect from Excel?    Please guide me if you have faced this issue.   Thanks in advance   Fri, 11 Jan 2019 18:17:00 GMT https://community.blueprism.com/t5/Product-Forum/Is-there-any-limit-for-Excel-get-Worksheet-as-a-range-action/m-p/65309#M17926 sai_bhargavaraj 2019-01-11T18:17:00Z Depends on number of columns… https://community.blueprism.com/t5/Product-Forum/Is-there-any-limit-for-Excel-get-Worksheet-as-a-range-action/m-p/65310#M17927 Depends on number of columns too, but 5000 should be fine. You start getting out of memory exceptions when you hit the limit. Mon, 14 Jan 2019 13:06:00 GMT https://community.blueprism.com/t5/Product-Forum/Is-there-any-limit-for-Excel-get-Worksheet-as-a-range-action/m-p/65310#M17927 AndreyKudinov 2019-01-14T13:06:00Z I've dealt with pulling 10… https://community.blueprism.com/t5/Product-Forum/Is-there-any-limit-for-Excel-get-Worksheet-as-a-range-action/m-p/65311#M17928 I've dealt with pulling 10,000 rows from Excel before without error but the limit may be affected by the number of columns as well. I've seen some people hit a 'seeming' limit at 4,000 but I'm not sure what the details were there. Mon, 14 Jan 2019 17:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Is-there-any-limit-for-Excel-get-Worksheet-as-a-range-action/m-p/65311#M17928 david.l.morris 2019-01-14T17:01:00Z If I remember correctly,… https://community.blueprism.com/t5/Product-Forum/Is-there-any-limit-for-Excel-get-Worksheet-as-a-range-action/m-p/65312#M17929 If I remember correctly, columns is a bigger drain on memory than rows. if possible, delete any columns you don't need before retrieveing the information (You could design a macro to do this and then call it using the VBO object). Wed, 16 Jan 2019 14:49:00 GMT https://community.blueprism.com/t5/Product-Forum/Is-there-any-limit-for-Excel-get-Worksheet-as-a-range-action/m-p/65312#M17929 OliverMohajeri 2019-01-16T14:49:00Z