Ventana software support forum

Hi

I am currently using Vensim to get data from an Excel workbook. The inputs are set up using cell references:

GET XLS CONSTANTS('Workbook', 'Worksheet' , 'A1' )

Everything works fine with this set up. We want to use Excel named ranges instead of cell references now and so I created a named range consisting of the cell required and then set up Vensim to read it like this:

GET XLS CONSTANTS('Workbook', 'Worksheet' , 'Named_Range' )

But this kicks out an error of 'Unable to get constant values'.

Any idea why this is happening? The named range refers directly to the cell.

Thanks

There is a know problem with named ranges that begin with 2 letters followed by something that is not a letter. If your named range is really 'Named_Range' it should be working in 5.10a on Windows (named ranges do not work on the Mac).

Will reading from named ranges (Excel Mac) work in the future?

It is on the list of things to do, but there is no schedule for getting it done.

Problem solved - I was unaware that I had to set the named range to include the whole range of data to be imported, not just the top left cell (as is usually given in the function).

Thanks!