Ventana software support forum

solved!

Thanks a lot!

Hi Bob, I have been looking for a solution, but found none. First of all I removed all the underscores in Vensim and renamed the named ranges in xls. When I run my model in Vensim 5.10b the error message is: "If startpos is a named range the value for time row/col must also be a named range&quo...

Hi,

Maybe, but tijd1 is a range with the same 'length' as the other range with the underscores.

Paul

Hello, When I use the Mac-version, I get an error that says that the named range is incorrect or non-contiguous. In the error message the named range is printed with capitals (PR_LTR_D), while the named range in the spreadsheet is pr_ltr_d. Is this maybe the cause of the error? I also noticed that v...

GET XLS LOOKUPS(sheet, 'dieselstad', 'tijd1', 'g_a_d_b_t')

This worked well in 5.9 and in 5.10x3, but in 5.10a and b it is not working anymore.

sheet is a string: the name of of the xls file.

Hi,

The problem didn't go away in 5.10b.
I still cannot read data from an Excelsheet using named ranges when there is an underscore in the name.
In Version 5.10x it works ok.

Kind Regards,

Paul

Thanks Bob!

GET XLS CONSTANTS('srdata.xls', 'dieselstad', 'pr_ltr_d')

So the problem is the underscore after <pr>.

Will this issue be solved in the near future?

When i upgrade from 5.10.x to 5.10.a, Vensim won't read in values from an xls-file (using GET XLS LOOKUPS). The message is that there might not be a 'live connection'. When I return to a previous version all works well again.
Is this a bug, or am I missing something that has been added or changed?

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

Hi,

Thanks for the OSX version.

I have a problem with reading data from XLS: it seems that GET XLS CONSTANTS is not working at all.

Paul

vensim 5.9ex5
excel mac 12.2.3
OSX 10.6.2