Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default 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.

  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to count how many cells a linked cell group occupies Kanaski79 Excel Worksheet Functions 7 September 23rd 05 08:49 PM
Keep cells in two different workbooks linked after delete/insert r KarenM Excel Worksheet Functions 0 September 22nd 05 05:41 PM
Linked cells JJC Excel Discussion (Misc queries) 2 February 16th 05 11:31 PM
Update linked cells within a workbook??? Chance224 Links and Linking in Excel 4 January 21st 05 06:33 PM
How do I extract cells from multiple workbooks Trevor Excel Discussion (Misc queries) 1 November 25th 04 10:59 PM


All times are GMT +1. The time now is 02:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"