| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
Hi Graham
Do you have Google desktop running ? -- Regards Ron de Bruin http://www.rondebruin.nl "Graham Tapper" wrote in message ... 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
|
|||
|
|||
|
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 ... 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
|
|||
|
|||
|
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 ... 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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need ability to leave certain cells of an worksheet editable. | Excel Discussion (Misc queries) | |||
| Protecting specific cells in a worksheet. | Excel Worksheet Functions | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| How do I ROUNDUP a Column of cells on a worksheet template? | Excel Worksheet Functions | |||
| How can I merge unlocked cells in a worksheet that has been protec | Excel Discussion (Misc queries) | |||
Linear Mode
