Excel - Copy Formulas without Workbook Reference

Excel's admirable attempt to keep formulas functional by including the full workbook name and path when copying and pasteing a forumla into a separate xls file is nice, but sometimes unwanted.

Some workaround options:

http://groups.google.com/group/microsoft.public.excel.worksheet.functions/browse_thread/thread/2d810006a638bccf/3c9c3422266186dc?lnk=st&q=excel+copy+and+paste+without+workbook+name&rnum=3#3c9c3422266186dc

For a large number of cells, I ended up doing the following:

- Switch to formula view in the Excel -> options
- copy and paste the formula cells (in bulk) into a good text editor, like EditPlus
- paste into the destination .xls file.
- Optionally, you can then copy and paste the formats between the two spreadsheet files.

By using a third party text editor, Excel can't maintain the address relative to the original spread sheet. So it all works out. -- really, there should be an easier way.