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.
>> Leonard Chan's Homepage
>> Scribble Web
>> Excel - Copy Formulas without Workbook Reference