ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Finding data links (https://www.excelbanter.com/excel-programming/397101-finding-data-links.html)

Lon Sarnoff

Finding data links
 
I have copied sheets from Workbook A into Workbook B. The sheets contain
macros. I have renamed the macros to reference the new workbook, B.
Nonetheless, now when I open Workbook B, I get the linked data update
warning. How can I locate what references are giving rise to that warning?



Gary Keramidas

Finding data links
 
try Bill Manville's findlink add in

http://www.bmsltd.co.uk/MVP/Default.htm


--


Gary


"Lon Sarnoff" wrote in message
...
I have copied sheets from Workbook A into Workbook B. The sheets contain
macros. I have renamed the macros to reference the new workbook, B.
Nonetheless, now when I open Workbook B, I get the linked data update
warning. How can I locate what references are giving rise to that warning?






All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com