Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Posts
    123
    Thanks
    13
    Thanked 1 Time in 1 Post

    Audit commands: bizarre behaviour (Excel 2002 SP3)

    For no apparent reason, suddenly my Audit / Trace Precedents and Trace Dependents commands no longer work properly, whether invoked from the menu or from the auditing toolbar.

    When I try to trace precedents (from a cell which has precedents, of course), the blue tracer line doesn't appear -- unless I type an = sign in the cell whose precedents I'm trying to trace, as though I were about to overtype the formula. Then the line appears, and I need to press ESC to avoid changing the formula.
    This is a workaround, but is not really acceptable -- I use the auditing commands very often, from an assigned shortcut key; having to do what I've described above will slow me way down.

    Tracing dependents doesn't work, and there's no obvious workaround. I've tried typing an = sign in a cell whose dependents I'm trying to find, and I get a blue trace line to the cell immediately below, whether the cell below is a dependent or not.

    Any advice?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Audit commands: bizarre behaviour (Excel 2002 SP3)

    Check out Jan Karel Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2007
    Posts
    123
    Thanks
    13
    Thanked 1 Time in 1 Post

    Re: Audit commands: bizarre behaviour (Excel 2002 SP3)

    Wow, how incredibly helpful -- thank you -- the problem vanished after trying out his first option, which is to launch Excel by typing the following: "C:Program FilesMicrosoft OfficeOffice10Excel.exe" /Automation. He says my success means the problem is either an add-in or a hidden sheet, which must be discovered by process of elimination.

    Quick follow-up question: at the moment I don't have time to do this. ISo in the meantime, is there any problem with me launching Excel as described above, and then opening the documents I need from within Excel?

    Thanks again,

    Lingyai




    That is one useful document. Thanks a lot.

    A quick follow up question: for now, u

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Audit commands: bizarre behaviour (Excel 2002 SP3)

    Starting Excel that way means that add-ins will not be loaded. Otherwise, Excel will function normally. So there is no objection to using /automation until you have time for further investigation.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •