ExcelBanter - How I do protect linked information if the link source is deleted

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How I do protect linked information if the link source is deleted (https://www.excelbanter.com/excel-worksheet-functions/116060-how-i-do-protect-linked-information-if-link-source-deleted.html)

moran

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?

Allllen

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?

romelsb

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?

All times are GMT +1. The time now is 09:55 PM.