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:


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.

Related Scribbles:
  • Excel Notes

  • ID: 746
    Date Updated:
    2006-02-08 15:46:55
    Date Created:
    2006-02-07 17:22:14


     >> Leonard Chan's Homepage  >> Scribble Web  >> Excel - Copy Formulas without Workbook Reference
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.