In workbook A I have several formulas that I have saved to a named range.
When I do a copy of that named range and paste it into a new workbook
(workbook B) the formulas reference/link to workbook A.....like this
=[WorkbookA.xls]Sheet2!A2. I don't want this to happen. I just want it to
paste the formula = Sheet2!A2.

How can I stop this in Excel 2007?

Thank you.