I want to delete some excel work books, but I'm not sure if this workbook's data have been used for some other excel work-books (through linking). So is there any way to identify the linked workbooks with that workbook.??
Is there any tool/function to identify the excel workbooks which are linked to a particular excel workbook?
If you have only a few workbooks, just open them
Go to Edit
Links
(Then you can see whether the workbook you want to delete is linked anywhere. )
But if you have a large no of worbooks, then this will make you tired. Google it , then you can find some free software that can do this.
Also you can just check with the auditing tool bar also. (Tools - Formula Auditing) . Just check whether if any of your totals or any other cells have any dependents.
No comments:
Post a Comment