| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Break link in formula in Excel 2007
I need to copy two Excel 2007 worksheets (WS1 & WS2) from one workbook to
another (WBX & WBY). WS1 has a formula referring to WS2. When I copy the two WS's from WBX to WBY, the formula refers back to WBX. I need to break this link to WBX so that the formula in WBY WS1 refers only to WBY WS2. Is there some simple way to do this? I don't know how to use VB yet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| break a link in excel 2003 | Excel Discussion (Misc queries) | |||
| Break link MS Excel 2000 | Excel Discussion (Misc queries) | |||
| How do i break a link to another excel workbook? | New Users to Excel | |||
| Break a link/formula but keep the data? | Excel Worksheet Functions | |||
| Can I break an external link in Excel 97? | Excel Discussion (Misc queries) | |||
Threaded Mode
