Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 11th 05, 01:45 PM
Graham Tapper
 
Posts: n/a
Default Trace ALL dependent cells in any worksheet anywhere in Excel

Would like ability to be able to trace all the dependent cells, on whatever
worksheet they appear, anywhere within a spreadsheet. Currently Excel will
not trace Text cell references or references to cells on other worksheets.
All it does is point an arrow to a picture of a worksheet but doesn't tell
you what worksheet(s) or what cell(s) within the worksheet(s).

  #3   Report Post  
Old March 11th 05, 02:14 PM
Jason Morin
 
Posts: n/a
Default

Aaron Blood's Explode add-in may interest you:

http://www.xl-logic.com/pages/explode.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Would like ability to be able to trace all the dependent

cells, on whatever
worksheet they appear, anywhere within a spreadsheet.

Currently Excel will
not trace Text cell references or references to cells on

other worksheets.
All it does is point an arrow to a picture of a

worksheet but doesn't tell
you what worksheet(s) or what cell(s) within the

worksheet(s).
.

  #4   Report Post  
Old March 11th 05, 03:11 PM
Graham Tapper
 
Posts: n/a
Default

Many thanks for this pointer. The Explode Add-in looks very interesting but
seems a bit flakey in operation. I've got a mysterious "Enter VBA_Explode
Password" box on the screen that won't go away!

"Jason Morin" wrote:

Aaron Blood's Explode add-in may interest you:

http://www.xl-logic.com/pages/explode.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Would like ability to be able to trace all the dependent

cells, on whatever
worksheet they appear, anywhere within a spreadsheet.

Currently Excel will
not trace Text cell references or references to cells on

other worksheets.
All it does is point an arrow to a picture of a

worksheet but doesn't tell
you what worksheet(s) or what cell(s) within the

worksheet(s).
.


  #5   Report Post  
Old March 11th 05, 03:31 PM
Ron de Bruin
 
Posts: n/a
Default

Hi Graham

Do you have Google desktop running ?

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Graham Tapper" wrote in message news
Many thanks for this pointer. The Explode Add-in looks very interesting but
seems a bit flakey in operation. I've got a mysterious "Enter VBA_Explode
Password" box on the screen that won't go away!

"Jason Morin" wrote:

Aaron Blood's Explode add-in may interest you:

http://www.xl-logic.com/pages/explode.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Would like ability to be able to trace all the dependent

cells, on whatever
worksheet they appear, anywhere within a spreadsheet.

Currently Excel will
not trace Text cell references or references to cells on

other worksheets.
All it does is point an arrow to a picture of a

worksheet but doesn't tell
you what worksheet(s) or what cell(s) within the

worksheet(s).
.






  #6   Report Post  
Old March 11th 05, 04:55 PM
Graham Tapper
 
Posts: n/a
Default

I have the Google Desktop Search. It's the Beta version.

"Ron de Bruin" wrote:

Hi Graham

Do you have Google desktop running ?

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Graham Tapper" wrote in message news
Many thanks for this pointer. The Explode Add-in looks very interesting but
seems a bit flakey in operation. I've got a mysterious "Enter VBA_Explode
Password" box on the screen that won't go away!

"Jason Morin" wrote:

Aaron Blood's Explode add-in may interest you:

http://www.xl-logic.com/pages/explode.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Would like ability to be able to trace all the dependent
cells, on whatever
worksheet they appear, anywhere within a spreadsheet.
Currently Excel will
not trace Text cell references or references to cells on
other worksheets.
All it does is point an arrow to a picture of a
worksheet but doesn't tell
you what worksheet(s) or what cell(s) within the
worksheet(s).
.





  #7   Report Post  
Old March 11th 05, 05:44 PM
Ron de Bruin
 
Posts: n/a
Default

See
http://www.dicks-blog.com/archives/2...oogle-desktop/



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Graham Tapper" wrote in message ...
I have the Google Desktop Search. It's the Beta version.

"Ron de Bruin" wrote:

Hi Graham

Do you have Google desktop running ?

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Graham Tapper" wrote in message news
Many thanks for this pointer. The Explode Add-in looks very interesting but
seems a bit flakey in operation. I've got a mysterious "Enter VBA_Explode
Password" box on the screen that won't go away!

"Jason Morin" wrote:

Aaron Blood's Explode add-in may interest you:

http://www.xl-logic.com/pages/explode.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Would like ability to be able to trace all the dependent
cells, on whatever
worksheet they appear, anywhere within a spreadsheet.
Currently Excel will
not trace Text cell references or references to cells on
other worksheets.
All it does is point an arrow to a picture of a
worksheet but doesn't tell
you what worksheet(s) or what cell(s) within the
worksheet(s).
.









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
Need ability to leave certain cells of an worksheet editable. Tyler Excel Discussion (Misc queries) 3 January 26th 05 05:19 AM
Protecting specific cells in a worksheet. GaryS Excel Worksheet Functions 2 January 6th 05 04:47 PM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
How do I ROUNDUP a Column of cells on a worksheet template? house mouse Excel Worksheet Functions 2 December 16th 04 06:49 PM
How can I merge unlocked cells in a worksheet that has been protec NeedMergeHelp Excel Discussion (Misc queries) 2 December 7th 04 01:20 AM


All times are GMT +1. The time now is 03:48 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017