Ventana software support forum

Hi,

In the model that I am making, one of the variables has to read data from excel (constants). In the equation I have added the
GET XLS CONSTANTS'filename.xls','sheetname', 'column name'), but when I try to run the simulation or partial simulation, I get an error saying "Unable to get constant vales." Please advice.

Hi,
Perhaps The problem is the Excel R1C1 Letters in the Global optios Settings

When you use the GET XLS CONSTANTS or GET XLS DATA functions Vensim queries Excel for this information. The appropriate format for this query is different for some international versions of Excel.

For check the correct ones letters for your Excel open the spreadsheet xlstest.xls in models\sample\extra and click on the button labeled Get Row and Column Labels (you will need to enable macros).

Rafael

With older versions you may need to change the R1C1 letters. It is best to update to the latest release that does not have this problem with international versions or Excel.