Here's a challenge to the Excel Guru's out there.
I have a workbook that is linked to many other books. Each week the path of the link changes to a different folder. I've parsed the path into several cells and only need to change a single cell with the new date and all of the parsed cells change according to the new date.
My problem is, after remerging the path into the destination cell(s), I'm trying reactivate that cell as a Link. So far, I've copied and pasted the values in the cell to change it from a formula to an address. Then when I select the cell (Edit Mode) and just hit Enter, it will become an active link again. Problem is, I have over 10,000 cells that need to be reactivated. This is a weekly report so this process is done regularly. Any ideas or suggestions????
Thanks for your expertise.
I have a workbook that is linked to many other books. Each week the path of the link changes to a different folder. I've parsed the path into several cells and only need to change a single cell with the new date and all of the parsed cells change according to the new date.
My problem is, after remerging the path into the destination cell(s), I'm trying reactivate that cell as a Link. So far, I've copied and pasted the values in the cell to change it from a formula to an address. Then when I select the cell (Edit Mode) and just hit Enter, it will become an active link again. Problem is, I have over 10,000 cells that need to be reactivated. This is a weekly report so this process is done regularly. Any ideas or suggestions????
Thanks for your expertise.