I have a search formula that refers to another open workbook. When other similar workbooks are opened my formula changes and the wrong directory path is substituted. I have used excel file/options/advanced/when calculating this workbook and removed ticks to (1) update links to other documents & (2) save external links. Neither of these solutions are 100% successful.
My formula fails to work if the path reference is changed. Is there a solution?
Bookmarks