| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How I do protect linked information if the link source is deleted
I've created sevreal workbooks that are linked to one large workbook. Is
there any way to protect the linked data if the original large workbook is deleted? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How I do protect linked information if the link source is deleted
How about closing the large workbook.
As long as you don't try to update the links, the other myriad workbooks will just keep the latest information that they have. -- Allllen "moran" wrote: I've created sevreal workbooks that are linked to one large workbook. Is there any way to protect the linked data if the original large workbook is deleted? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How I do protect linked information if the link source is dele
thats right Allllen....I guess Mr. MORAN can saveAS now the One Large
Workbook in another file as Link-backup.... say if your original filename is MYNAME.xls....saveAS MYNAME2.xls...as soon as possible.... "Allllen" wrote: How about closing the large workbook. As long as you don't try to update the links, the other myriad workbooks will just keep the latest information that they have. -- Allllen "moran" wrote: I've created sevreal workbooks that are linked to one large workbook. Is there any way to protect the linked data if the original large workbook is deleted? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I update data in linked cells without opening source workbo | Excel Worksheet Functions | |||
| Protect - Unprotect Sheet - Visual Source Safe | Excel Discussion (Misc queries) | |||
| Link cell between WS w/o dest display 0-jan if no entry at source | Excel Worksheet Functions | |||
| Link excel and word in mail merge without losing your data source? | Excel Discussion (Misc queries) | |||
| How to keep linked cells blank until information is entered? | Excel Worksheet Functions | |||
Linear Mode
