LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Find Linked Cells

Anyone know of a way to scan all Excel files in a drive to
find out if they have external links?

The issue is that our drive mappings are about to change
so a cell that contains a link to T:\workbook.xls should
now be pointing to G:\workbook.xls. I would like to be
able to scan all network drives for any Excel files that
contain linked cells so that I do not have to open each
one individually and go through Edit-Links to find them.
Is this possible or am I dreaming?

Thanks!
 
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
Sorting non-linked cells in a linked worksheet Gary Excel Discussion (Misc queries) 1 October 25th 08 03:38 AM
Linked Cells Staying With Cells Once Linked Workbook Update. [email protected] Excel Worksheet Functions 0 June 6th 06 09:32 AM
How do I find cells with linked content Cowtoon Excel Discussion (Misc queries) 5 January 19th 06 12:38 PM
How to find linked cells anoop Excel Discussion (Misc queries) 1 November 2nd 05 08:26 AM
Find/Replace Linked Cells Prompts File Location Inquisitive1 Links and Linking in Excel 4 October 20th 05 01:40 PM


All times are GMT +1. The time now is 10:49 AM.

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

About Us

"It's about Microsoft Excel"