Graphics

Has anyone else experienced this issue, and if so, how did you fix it? I'm working with a client (PA Lottery) and building the lottery recap screen in xpression. I have the scene built already, and we are using an Excel sheet to populate the text cells using Excel datalinq. Everything works as designed if we are in Layout mode, but in Sequence Xpression locks up when we execute an Excel macro to clear the Excel cells. This only happens in Sequence mode. Any ideas out there as to what to look for? It's a new machine (less than a month old) and has only been used for this project so far. Version 5.7 Build 3064.

I haven't seen that issue before, but I would recommend you try to use the ADODB datalinq instead of the Excel datalinq if you can. The ADODB datalinq can still access your data in excel, but it treats it more like a database rather than talking directly to excel.

You can watch the datalinq Part 1,2,3 videos here for details on how to setup the ADODB datalinq to connect to Excel: http://xpression.rossvideo.com/videos/

#XPression

To outline a few advantages of the ADODB datalinq versus the Excel data..

1. It can read XLS files even when Excel is not installed on the machine.

2. It can run SQL queries on the data in excel to perform lookups, searches, sorting, filtering etc.

#XPression

We've been using the Excel datalink for years at another station before they lost the lottery contract. I didn't want to use the ADODB link because as I understand it, the excel page would have to be saved first before the cells on the recap screen are populated. The client wants to see the numbers immediately as they are typed.

#XPression

Yes you're right about the page needing to be saved first..

You might need to contact tech support and provide them with the project and excel sheet to investigate the issue.

#XPression

I am having the same problem, I made a linq date ADODB but he sought the file and returned to the original format, if the file is open it gives this error.

@bford

#XPression