Page 1 of 1

Error Excel data import

Posted: Sat Sep 11, 2010 10:58 am
by walin
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

Posted: Sat Sep 11, 2010 11:03 am
by Administrator

Posted: Sat Sep 11, 2010 11:23 am
by walin
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]

Posted: Sat Sep 11, 2010 11:35 am
by walin
So strange that it worked at the uni of several computers but not on my laptop at home... Could it be windows vista?