| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn off linking in Excel 2007?
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off auto recover in Excel 2007 | Excel Discussion (Misc queries) | |||
| Turn off compatibility Checker in Excel 2007? | Excel Discussion (Misc queries) | |||
| How can I turn back on my sort options in excel 2007? | Excel Worksheet Functions | |||
| How can I turn back on the sort button in excel 2007? | Excel Discussion (Misc queries) | |||
| 2007 Excel Pivot Tables - turn off subtotals | Excel Discussion (Misc queries) | |||
Linear Mode
