Originally posted by: bilbeisi9

Hello,

I'm working on a production scheduling project for a company called "Dairy Foods". I seem to have only a couple of errors left, all concerning the link to the Microsoft Excel sheet. I keep getting the same error over and over again: Exception from IBM ILOG Concert: Excel range is unknown.  Im going to attach the excel worksheet and the CPLEXcode on a word document. I am in desperate need of help for my project is due in two days. Someone help, thanks!

Since this question is related only to OPL you should ask it on the OPL Forum.

Before doing that you should double check your files. For example, I can see in your data file

RData from SheetRead(sheet,"'Distrubution Cost'!A2:D271");

while the sheet in the Excel file is called 'Distribution Cost' (note the 'i' instead of the 'u'). Such mismatches could be the reason for unknown ranges, I think.

Originally posted by: bilbeisi9

I made sure that the spelling mistakes were matched so i doubt that is the cause of the errors. I also reposted the topic in the correct forum, thanks for notifying me.