Formule not refreshing

[Bandito1]

Hey all, i use the following code to pull data from another workbook;

=IF(INDEX('P:\000 Dashboard Production\Tabellen nieuw\[Bezetting 2019.xlsx]Planning'!$A$6:A69;ROW())=0;"";INDEX('P:\000 Dashboard Production\Tabellen nieuw\[Bezetting 2019.xlsx]Planning'!$A$6:A69;ROW()))

The data in this file can change and I would like that this formula refreshes each time i open my workbook.
But i notice it doesn't.

Only when i manually pull the formula down it refreshes. Not when I open the workbook.

Anyone knows how i can change this?

Edit: Calculation options is already set on automatic

 

[pgc01]

Hi

In the Edit Links dialog what's the option checked in the Startup prompt?

 

[Bandito1]

Hey,

Sorry for the late repy, i had vacation.

Where can i find the edit links dialog?