logo

Live Production Software Forums

www.vmix.com

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
EXCEL as data source live - Problem with live data from excel to VMIX
Options
Go to last post Go to first unread
Previous Topic Next Topic
Niklas Elste  
#1 Posted : Monday, April 29, 2024 6:34:51 AM(UTC)
Niklas Elste

Rank: Newbie

Groups: Registered
Joined: 4/29/2024(UTC)
Posts: 2
Sweden
Location: Köping
Hi im doing a livestream that demands i have a dataselection of diffrent teams

im doing it with datavalidation in excel

it works perfect except for not updating live from excel i need to close excel for VMIX to get the data

how do i solve my problem???
Back to top
WWW

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
dmwkr  
#2 Posted : Monday, April 29, 2024 6:35:25 PM(UTC)
dmwkr

Rank: Advanced Member

Groups: Registered
Joined: 2/23/2019(UTC)
Posts: 555

Thanks: 62 times
Was thanked: 130 time(s) in 118 post(s)
Just saving the Excel file should be sufficient, and setting an adequate refresh rate in the Data Sources Manager.
Back to top
Niklas Elste  
#3 Posted : Tuesday, April 30, 2024 12:54:17 AM(UTC)
Niklas Elste

Rank: Newbie

Groups: Registered
Joined: 4/29/2024(UTC)
Posts: 2
Sweden
Location: Köping
Sadly it dont work

as long i have it open in excel vmix cant read the file
Back to top
WWW
kross  
#4 Posted : Tuesday, April 30, 2024 5:37:57 AM(UTC)
kross

Rank: Advanced Member

Groups: Registered
Joined: 10/31/2020(UTC)
Posts: 144
United States

Thanks: 2 times
Was thanked: 28 time(s) in 28 post(s)
I've never used actual MS Excel for this. I've only used LibreOffice Calc. Maybe Calc doesn't keep a lock on the file like Excel does. Is using Calc a viable alternative?
Back to top
richardgatarski  
#5 Posted : Wednesday, May 1, 2024 12:15:06 AM(UTC)
richardgatarski

Rank: Advanced Member

Groups: Registered
Joined: 2/18/2014(UTC)
Posts: 1,837
Location: Stockholm

Thanks: 144 times
Was thanked: 297 time(s) in 250 post(s)
Originally Posted by: Niklas Elste Go to Quoted Post
Sadly it dont work as long i have it open in excel vmix cant read the file

When we used Excel as a datasource (a few years ago), we had to Save in Excel so that vMix could grab it, but was not necessary to close Excel.
Back to top
WWW
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.120 seconds.