LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Sheet Dependants

You could search for the worksheet name (look through formulas).

But those links could be hidden in lots of places (names, charts, ...).

I like to make a copy of the workbook (so I don't damage the original).

Then I'll move the worksheet to a new workbook (Edit|Move or copy sheet in
xl2003 menus).

Then I can use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

And if you're working with names, I'd get this, too:
Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager:
NameManager.Zip from http://www.oaltd.co.uk/mvp



Mitch Powell wrote:

I delete what I think is a standalone sheet only to find that other places in
the workbook sepend on cells in the sheet. Does anyone know of a utility or
add-in that will search a workbook and identify any references to a sheet?


--

Dave Peterson
 
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
excel sheet bootom half sheet goes behind top part of sheet rob Excel Worksheet Functions 2 January 17th 09 01:28 AM
Trace dependants/precedents from another worksheet Atreides Excel Discussion (Misc queries) 7 August 13th 08 03:26 PM
Can I trace dependants for a multiple selection? BMA Excel Discussion (Misc queries) 2 April 11th 07 01:10 AM
Trace Dependants Not Working... voyeurs Excel Worksheet Functions 0 December 4th 05 02:41 PM
Trace Dependants NICK Excel Discussion (Misc queries) 0 May 18th 05 08:16 AM


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

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"