| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
i have linked 2 workbooks by mistake, how do i undo this
I was trying to save a particular tab and saved the whole workbook by
mistake, I deleted the new workbook, but there is now a link between the 2, how do I undo this? It is sensitive info so I cannot have anyone alter it |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
i have linked 2 workbooks by mistake, how do i undo this
Not suer I understand the question.
How do you have a link between two workbooks if you deleted one of them? Did you really delete it or is it just sitting in your recycle bin? -- Brevity is the soul of wit. "kkirstyy" wrote: I was trying to save a particular tab and saved the whole workbook by mistake, I deleted the new workbook, but there is now a link between the 2, how do I undo this? It is sensitive info so I cannot have anyone alter it |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
i have linked 2 workbooks by mistake, how do i undo this
You can try EditLinksBreak links.
Note: this will change any linked formulas to values. Gord Dibben MS Excel MVP On Thu, 24 Aug 2006 06:28:02 -0700, kkirstyy wrote: I was trying to save a particular tab and saved the whole workbook by mistake, I deleted the new workbook, but there is now a link between the 2, how do I undo this? It is sensitive info so I cannot have anyone alter it |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sharing Linked Workbooks | Excel Discussion (Misc queries) | |||
| Linked network workbooks revert to pointing at my hard drive | Excel Discussion (Misc queries) | |||
| linked cells to workbooks in different folders | Excel Discussion (Misc queries) | |||
| LINKED WORKBOOKS - TOTAL CONFUSION | Excel Worksheet Functions | |||
| Updating linked workbooks | Excel Discussion (Misc queries) | |||
Hybrid Mode
