Forum Discussion
variable part in function
Dear people, 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...
INDIRECT requires the linked file to be open in Excel. I would use the fixed link and then go into the Data, Edit Links dialog to change the link.
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!