Re: Trace ALL dependent cells in any worksheet anywhere in Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JulieD (JulieD_at_hctsReMoVeThIs.net.au)
Date: 03/11/05 

Date: Fri, 11 Mar 2005 22:07:50 +0800

Hi Graham

you can email MS with a suggestion at
mswish@microsoft.com

put Excel in the subject line

Cheers

JulieD

"Graham Tapper" <Graham Tapper@discussions.microsoft.com> wrote in message
news:4F529F16-616A-4F3E-94C6-5A619325D367@microsoft.com...
> 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).

Relevant Pages

  • Re: Embedded Excel
    ... when the worksheet is very long. ... First, open your Excel worksheet. ... Copy the selected cells to the clipboard. ... Switch to your Word document and position to the place ...
    (microsoft.public.word.formatting.longdocs)
  • Definite mind-twister for an Excel MVP
    ... also editable cells for the salerep user to enter forecasting information. ... To make the spreadsheet easy to use, all cells are Protected except the ... you that the worksheet is protected instead of collapsing or expanding the ... However, I cannot figure out how to add the code in from ASP.NET, as Excel ...
    (microsoft.public.excel.programming)
  • Re: Copy Changes in one workbook to another identical Master Workb
    ... 'Excel 2000 VBA programmer's reference' by 'John Green, Stephen Bullen, Felipe Martins', and then I have followed this news group for some years. ... I did this because I have formatting and formulas in cells and apparently ... Dim wbA As Workbook ... Dim shA As Worksheet ...
    (microsoft.public.excel.programming)
  • Re: How to use automation Add-In to replace Excel macros!!
    ... sForm = cell.formula ... > Based on the reply I created a toolbar button in excel which calls a Excel ... > On debugging I saw it failed in cases where cells are merged. ... > worksheet 5 can refer to some field in worksheet 1. ...
    (microsoft.public.excel.programming)
  • Re: Office 2003 v Office 2000 - VBA
    ... There have been no changes to the VBA language from Excel 2000 to 2003 (do ... translate Help examples into meaningful worksheet data, ... Watch window Keep track of cells and their formulas on the Watch Window ...
    (microsoft.public.excel.programming)