Error Excel data import

walin · Post by **walin** » Sat Sep 11, 2010 10:58 am

Dear all,

I was working in my model on another computer and everything worked fine. Now I am working on my laptop en get this error:

ERROR: Range (or named range) R3C1:R52C1 in file Inputs.xls (sheet August) incorrect or noncontiguous.
ERROR: Unalbe to get data values for "E-demand per hh (J)".
ERROR: Failed to make live links to data - aborting simulation.
ERROR: Unable to correctly load in exogenous values - aborting.

Anyone have an idea how to solve this?
thanks

Post by **Administrator** » Sat Sep 11, 2010 11:03 am

It's a known problem.

You can get some more info at
http://www.ventanasystems.co.uk/forum/v ... php?t=4211
or
http://www.ventanasystems.co.uk/forum/v ... php?t=4207

walin · Post by **walin** » Sat Sep 11, 2010 11:23 am

Thanks for the quick reply. But I do not use named range, I use this input:
GET XLS DATA('Inputs.xls','August','A', 'E3')

I use 5.2 DSS by the way (which seems to be an old version, but the only one available on my university...)

[Edited on 9-11-2010 by walin]

walin · Post by **walin** » Sat Sep 11, 2010 11:35 am

So strange that it worked at the uni of several computers but not on my laptop at home... Could it be windows vista?