GET XLS CONSTANTS named range

[smuffff]

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

[bob@vensim.com]

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).

[ppmvanhooff]

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

[bob@vensim.com]

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

[smuffff]

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!