I have an excel workbook that has linked cells in it to another workbook/file. Now this other workbook/file has some links to a third workbook/file, and so on. I have used INDIRECT.EXT and the Morefunc add-in, but this only works for the first linked worksheet. Is there a way to write a maro that opens, and then closes, all linked workbooks in the sheet just to update the linked cells? If it works correctly than I can open the first workbook, the macro will automatically open the second workbook, and the macro in that workbook will open up the thrid workbook. In these workbooks there are multiple links to multiple worksheets, can the marco check that if a link exists anywhere in the workbook then open it?