I don't know how you guys handle this problem.
Once in a while, I need to replace the links in the 1000 cells from one files to another file. I use replace. If I type incorrectly the new links, then the excel will open a standard "Openning a file" window for EVERY cells. In my case, locating a same file for 1000 times is gonna kill me. But I don't know how to get around this annoying problem but to kill the excel process without saving it. Sometime, I have done so much work but I have to do it again.
Anyone has any better way?
Thanks
Once in a while, I need to replace the links in the 1000 cells from one files to another file. I use replace. If I type incorrectly the new links, then the excel will open a standard "Openning a file" window for EVERY cells. In my case, locating a same file for 1000 times is gonna kill me. But I don't know how to get around this annoying problem but to kill the excel process without saving it. Sometime, I have done so much work but I have to do it again.
Anyone has any better way?
Thanks