how to get a worksheet to update without opening another workbook and without using vba

shina67

Board Regular
Joined
Sep 18, 2014
Messages
61
Hi All,

I have a workbook that pulls data from another workbook.
At present both workbooks have to be open for the data to pull through.
What I am wanting is a way to pull the data from 'workbook1' to 'workbook 2' without 'workbook 2' being open.
I cannot use vba as I also have another workbook open at all times that uses vba and this would cause issues.

Is there a way of pulling the data through without 'workbook 2' being open.
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,231
how do you check if wkb2 is updated?
 
Last edited:

shina67

Board Regular
Joined
Sep 18, 2014
Messages
61
Workbook 2 is updated manually once a day.
Workbook 1 is a visual dashboard on other pc's.
What I am trying to avoid is a time consuming exercise of having to go around all the pc's with the dashboard on open workbook 2 so that workbook 1 updates.
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,231
you said wkb2 is closed so I asked how do you check CLOSED workbook :)

try PowerQuery
define Query in wkb2 calling data from wkb1 with define Refresh time in Connection
 

Forum statistics

Threads
1,077,895
Messages
5,337,054
Members
399,120
Latest member
Sravankumar

Some videos you may like

This Week's Hot Topics

Top