Range address is not valid

Error message

This step has failed because the range address “from A3 to Last cell in column B” in worksheet “{sheetName}” in the workbook “ErrorValues.xls” appears to be LowerLeft:UpperRight e.g.C10:E2, this is not supported in the system. Please review the instruction and check that this range address evaluates to acceptable format which is UpperLeft:LowerRight e.g.C2:E10 in this workbook. 

Why does this happen?

File instruction cannot identify data in the specified advanced range in the excel file. Consequently, instruction starts looking the data in the reverse order from lower left to upper right. While this is possible manually in MS Excel, file instruction cannot perform this action in SolveXia system. File instruction in SolveXia system supports data reading from upper left to lower right direction.

How to fix this

Download and review the MS Excel file, check the specified advanced range in the instruction and ensure that specified advanced range flows data from upper left to lower right direction.

Below is an example of supported and not supported range directions in SolveXia.

Leave a Reply

Latest Tweets

Free eBook: 10 Tips for sourcing good data yucalc.com/2017/02/17/fre…

reply · retweet · favorite

Newsletter

By signing up, you agree to our Terms of Service and Privacy Policy.

Address

Suite 1506, Westfield Tower 2, 101 Grafton St Bondi Junction NSW 2022 Australia

View Larger Map

Contact Us

AUS: +61-2-9386-0202
UK: +44-20-8123-1251
Send us an email

ContactUs.com
WordPress Image Lightbox