Ventana Systems UK Forum Last active: Never
Not logged in [Login - Register]
Search the forums Search   Frequently Asked Questions FAQ   Today's Posts Today's Posts   Forum Stats Stats   Forum Rules Board Rules Back to: Ventana Systems UK
Ventana Systems UK Forum » Vensim » No GET XLS CONSTANTS in version 5.10.a Go To Bottom

Printable Version | Subscribe | Add to Favourites   Post new thread Poll:
Author: Subject: No GET XLS CONSTANTS in version 5.10.a
ppmvanhooff
Junior Member
**



Posts: 4
Registered: 2-20-2010
Member Is Offline


[*] posted on 9-10-2010 at 08:39 Reply With Quote
No GET XLS CONSTANTS in version 5.10.a

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?
View User's Profile View All Posts By User U2U Member
bob@vensim.com
Administrator
********



Posts: 1009
Registered: 3-12-2003
Member Is Offline

Mood: No Mood.

[*] posted on 9-10-2010 at 09:35 Reply With Quote


There is a known problem if you are using a named range that begins with 2 letters followed by a nonletter. What is the call that is causing the problem for you?
View User's Profile View All Posts By User U2U Member
ppmvanhooff
Junior Member
**



Posts: 4
Registered: 2-20-2010
Member Is Offline


[*] posted on 9-10-2010 at 12:56 Reply With Quote


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?
View User's Profile View All Posts By User U2U Member
Post new thread Poll:


 Ventana Systems UK Forum  » Vensim » No GET XLS CONSTANTS in version 5.10.a Go To Top


Powered by XMB
Developed By Aventure Media & The XMB Group © 2002-2006


[queries: 15]
[PHP: 81.4% - SQL: 18.6%]