ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to identify cells which failed in Update Links (https://www.excelbanter.com/excel-discussion-misc-queries/89498-how-identify-cells-failed-update-links.html)

Mark Brody

How to identify cells which failed in Update Links
 
On opening a workbook one might receive the message: This workbook contains
links to other data sources. One can then click: Update. Then one might get
the message: one or more links cannot be updated. One then clicks: Edit. And
it shows the sources that have failed.

How can I identify which cells in the current workbook are the ones that are
linked to the failed sources?


All times are GMT +1. The time now is 06:01 PM.

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