ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Finding linked cells to other workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/51397-finding-linked-cells-other-workbooks.html)

[email protected]

Finding linked cells to other workbooks
 
I have some workbooks that ask me if I wish to update links and I can't
find the links in the workbook. Some of my worksheets I did a copy and
paste special values, but there are a few worksheets that I can't do
this on. I need to be able to find the linked cell and eliminate it so
that the pesky message to update links doesn't appear when the workbook
is opened.

I'm sure there should be a simple solution to this, I just don't know
what it is?

Thanks for any help.


Dave Peterson

Finding linked cells to other workbooks
 
When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

" wrote:

I have some workbooks that ask me if I wish to update links and I can't
find the links in the workbook. Some of my worksheets I did a copy and
paste special values, but there are a few worksheets that I can't do
this on. I need to be able to find the linked cell and eliminate it so
that the pesky message to update links doesn't appear when the workbook
is opened.

I'm sure there should be a simple solution to this, I just don't know
what it is?

Thanks for any help.


--

Dave Peterson


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

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