use INDIRECT function in reference to other sheet

[huli601]

Hi,


Last few years I spend a lot of time in one excel file where are 62 sheets (1D, 1N, 2D, 2N, 3D, ... represent shifts in month (day/night)). One every sheet are use complicate references to other workbook. For simple example: on sheet 1D is use following reference: ='\\192.168.0.23\2018\[april.xlsx]1D'!$A$1 (in real it´s much complicated). I can not use function indirect in this reference, so when I want to make some changes I always have to change it manualy on every 62 sheets.
I try to find solution where I can use function INDIRECT and "get sheet name" (I alreary have this function) for this reference. ='\\192.168.0.23\2018\[april.xlsx]1D'!$A$1


thank you for answers

 

[RoryA]

INDIRECT will only work with an open workbook.

 

[huli601]

I know, I try to find solution also for closed workbook

 

[RoryA]

I'd suggest either Find/Replace or the Edit Links dialog are better alternatives.