Breaking Links in Excel
Can some one in this forum tell me a way to break links in Excel while retaining the formula within that cell? In other words, if I have a Workbook called 'Book Two', and in one of those cells I have the following:
"='\\folder\[Book One.xls]Sheet1'$C$15+$D$10"
is there a quick way to change it so it simply references my current workbook, like so:
"=$C$15+$D$10"
I need this to be done for lots of cells, and I'd love to figure out a way to shorten the process so I don't have to go in and manually edit the formula for each cell.
|