We help IT Professionals succeed at work.
Get Started

Real time update using Excel thats linked to a second worksheet on same network

Michael Smith
Michael Smith asked
on
12 Comments
1 Solution
53 Views
Last Modified: 2017-05-22
Hey guys,

I am planning in using Excel to display data on a largeTV for Real time analysis by staff members..

What I would like is to have 2 excel files ...

DisplayFile and DataFile...

The DisplayFile.xls  will be open on a win7 machine connected to the large TV and a secondary Datafile.xls will will have unique data manually entered throughout the shift and I would like this data to automatically update on the TV.

Currently this all works fine when both files are open on the same physical machine but if I move the files to either a network share or different machines then the auto update doesn't work...

Naturally the display file document reference the data in the Datafile of Excel....

ANy advice?
Comment
Watch Question
Partner
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 12 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE