|
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). |
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). . |
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). . |
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). . |
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). . |
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). . |
| All times are GMT +1. The time now is 05:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com