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!
Search found 2 matches
- Fri Sep 24, 2010 12:41 pm
- Forum: Vensim
- Topic: GET XLS CONSTANTS named range
- Replies: 4
- Views: 3616
- Mon Sep 06, 2010 10:52 am
- Forum: Vensim
- Topic: GET XLS CONSTANTS named range
- Replies: 4
- Views: 3616
GET XLS CONSTANTS named range
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 c...