replacing indirect.ext

[grazhopa]

i have recently inherited a spreadsheet which has fallen into disuse due to staff turnover. unfortunately it was setup using indirect.ext

i dont fully understand it but from what i have discovered, i need to install an extension to use it - unfortunately corporate policy and it lockdowns stop me doing that.

is there an easy way to replace the indirect.ext links with something else?

i am using 2007.

do indirect.ext and indirect use the same syntax? i tried a simplistic swap indirect.ext for indirect but get a #ref! error




the sheet currently uses this

Please Login or Register  to view this content.

to reference three cells on the Data sheet which specify folder/file name / worksheet

any ideas?

[Pete_UK]

INDIRECT does not work with closed workbooks, but the function INDIRECT.EXT (part of the morefunc add-in) does allow you to use closed workbooks. It uses a similar syntax, although it will include references to the full path and filename, whereas INDIRECT does not need those specifically if the external file is open at the same time. If you want to use INDIRECT, then you must ensure that the external workbook is open in the same instance as the workbook with the formula in.

Hope this helps.

Pete

[grazhopa]

yeah i tried replacing indirect.ext with plain old indirect, had the file open but still get the ref error.

at this stage i'm probably just going to do a dirty bodge job to get my sheet working without the fancy links.

ta