Please review the note What are the Web ADI Requirements to work with Excel 2010? (Doc ID 1272346.1) and check whether you have the necessary Web ADI patches in place for office 2010 on your EBS.
Please review the note Upload Webadi Runtime Error 9 And Subscript Out Of Range (Doc ID 1600223.1).
If the issue is still not resolved, Please provide the below details.
Is this issue specific to a particular integrator alone?
What is the integrator name, Is it standard or custom?
Please upload the BNE log.
Please mark any update as "Correct Answer" or "Helpful Answer" if that update helps/answers your question, so that others can identify the Correct/helpful update between many updates.