Cascading drop-down from spreadsheet


I need some assistance, I am creating a SP but I need to do a look up or cascading drop down using information from a spreadsheet from InfoPath.

Can anyone guide me? All I can find info about is for cascading from a list, but it is a spread sheet

Any tutorial or forum?


October 30th, 2014 8:54pm


If you are talking about list datasheet view then unfortunately datasheet view does not supports cascading DDL. I am not aware about any third party tool or solution for datasheet view. Personally i modify the list form in infopath or apply jquery in such kind of requirement.

Free Windows Admin Tool Kit Click here and download it now
October 31st, 2014 9:02am


In addition to Hemendras suggestion, you can take a look at the link below about how to access Excel file which stores in a SharePoint Library using Excel Web Service with jQuery:

Best regards,

November 7th, 2014 4:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics