Unfortunately I think I know the answer to this. I often do vlookups to other workbooks and love being able to copy/paste values simply by using the "Break Links" function. Lets me leave some formulas up, while getting rid of others. I'm currently in a workbook that has about 15K vlookups to other tabs. There are a lot of different sections, so rather than having to highlight an area and copy/paste values, go to the next area, repeat, multiple times to remove the formulas, I'm wondering if anyone has any ideas on a way to remove the references to the other tabs quicker. Thoughts?
Bookmarks