+ Reply to Thread
Results 1 to 2 of 2

Trace Depenents suddenly stopped working for some cells.

  1. #1
    Registered User
    Join Date
    12-02-2011
    Location
    Beijing, China
    MS-Off Ver
    Excel 2010
    Posts
    36

    Trace Depenents suddenly stopped working for some cells.

    I have an excel workbook, about 8MB, with many assumptions. Some of these assumptions have hundreds of dependents, but now when I click Trace Dependents excel is saying there are none. The formulas that refer to the assumptions are still changing when the assumptions change. Is this common in excel? I've found some some people who have had the same thing happen, but no solid reason to why it happened. This is using Excel 2010
    Last edited by hlep; 03-27-2012 at 10:03 AM.

  2. #2
    Registered User
    Join Date
    12-02-2011
    Location
    Beijing, China
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Trace Depenents suddenly stopped working for some cells.

    Solution was moving all sheets to a new workbook, then restarting excel.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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