gismo
Touchdown! Greaser!
Is there any way to copy formulas from cells from workbook to workbook without Excel adding workbook (file) references? Say I have a cell in book1.xls that's the product of the value in two other cells in that same workbook and I want to make a separate but identical copy of all that in book2. If I cut and paste the cell with the product formula refers to the multiplacands in book1 rather than the copies in book2. I looked at all the options in the "paste special" menu and couldn't find anything useful there. So far the only way I found to do this is to edit and copy the text of the formula and paste that. Unfortunately this way I can only copy one formula cell at a time and of course none of the formatting gets copied at the same time.
Last edited: