I have a document with some VLookup() calls in it, which refer to an external file.
I want to copy this sheet into a different document.
If I copy / paste or Copy Sheet, the formulae break (unable to locate the external file, giving REF? errors).
Solution comes courtesy of http://www.openofficetips.com/blog/archives/2005/01/copying_formula.html
Find & Replace
(Search in formulae)
Replace = with #.
This changes forumlae into harmless text strings.
Copy/paste the cells containing these text strings.
Search / Replace # back to =.
The text strings revert back to real formulae again.