Graphics

I'm new to the world of Ross-Expression.. The question (the title) says it all.

And I need to use Excel as my database.
The links work, but I'd like to improve my workflow.

• Is it possible to update DataLinq data in XPression without having to manually save (Ctrl+S) the Excel file?

• Is it possible to dynamically update value fields directly on the On-Air video output, bypassing the Sequencer?
  (I checked the "update" box, but I'm still forced to go through my sequencer.)
  Thank you for your helpful answers.
  
  my choices :
  

Excel is annoying for XPression because of the sharing settings.  The old .xls would let it be open & accessed by multiple users, but the newest excel wants only one user accessing it at a time. One workaround I've found is to save the regular excel file using the Google Drive app, which fools the OS into thinking Drive is a mounted HDD letter. The downside to that is Drive sometimes is slow to see the changes, it may not work for live scores.

Jean, 

It is not possible to update Datalinq in XPression without saving the excel file. Datalinq is reading the file saved to disk, rather than what's live in the open Excel workfbook.

The new .xlsx file can be used, but on machines with 64-bit versions of Microsoft Office, you have to install the 32 bit Access Database Engine for Datalinq to read Excel file.

https://support.rossvideo.com/hc/en-us/articles/5382092783771-XPression-Installing-Access-Database-Engine-ACE-with-64-bit-Microsoft-Office

Multiple users can access the file as long as its set up to use Legacy Sharing in Excel

https://www.rossvideo.com/blog/u_tutorials/80997/

With these two configurations, the Datalinq Source set to refresh every second as you have, and the Live Update button checked in the Datalinq options on the text object in XPression, the scene should update on-air within a second of saving the new data in Excel.