can somebody help me with the following issue, since my tries are not leading to the solution.
I am using a reference cell from another file, which has a week number in its filename, so this changes every week. The week after my reference cells will not work anymore.
Now I would like to make this weekpart variable, so this would make it easy for me to change this information on 1 place, instead of changing all the reference cells. Below there is just 1 cell, but I need 36 cells. Otherwise I have to update 36 cells every week by hand.
Ah that is the case. The other file was not open, but I will take a look into the suggestion you made Data, Edit links dialog. Don't know much about this, but I will first look into this myself. Thank you for your response!