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

[shina67]

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]

how do you check if wkb2 is updated?

 

[shina67]

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]

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