+ Reply to Thread
Results 1 to 3 of 3

I can't make Formula Auditing

  1. #1
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    I can't make Formula Auditing

    I select all the cells and click Trace Dependents or Trace Precedents and It says "The Trace Precedents command requires that the active cell contain a formula which includes valid references." So I can't make Formula Auditing. Why?
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: I can't make Formula Auditing

    The active cell is just one of the selected cells - the top left by default. This might not contain a valid formula.
    Martin

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,329

    Re: I can't make Formula Auditing

    Select just 1 cell and click Trace Dependents or Trace Precedents
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula Auditing
    By shakra in forum Excel General
    Replies: 12
    Last Post: 07-24-2012, 02:31 AM
  2. Formula auditing help
    By MickeyGreen in forum Excel General
    Replies: 0
    Last Post: 01-26-2009, 03:09 PM
  3. Formula Auditing
    By herbh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-14-2008, 08:43 PM
  4. Formula auditing!
    By MattShoreson in forum Excel General
    Replies: 0
    Last Post: 10-11-2006, 09:38 AM
  5. [SOLVED] Formula auditing inactive
    By mthomas4 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-22-2006, 05:10 AM
  6. [SOLVED] Formula auditing unavailable
    By CinqueTerra in forum Excel General
    Replies: 1
    Last Post: 07-13-2006, 12:35 PM
  7. Formula Auditing
    By Jeff in forum Excel General
    Replies: 1
    Last Post: 03-01-2006, 11:20 PM
  8. [SOLVED] FORMULA AUDITING
    By FLKULCHAR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2005, 10:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1