I tried posting this question on another site and haven't gotten an answer. Here's a link to that post.

http://www.mrexcel.com/board2/viewtopic.php?t=273624

I tried searching this site and did find someone that also had this problem. It was never resolved so I'm trying again.

Here's the details of the problem.

This is the 1st time this ever happened to me. My trace precendent tool is working, but my trace dependent tool isn't. I know for a fact that the active cell affects other cells. If I open up an older version of the file, both tools are working. It's just this month's version. I even tried starting over by opening last month's version, saving under a new name and adding the new data. As soon as I add the new tab, this is a problem.

Does anyone know what could be causing this?

Here’s a history of my files. January I create a file with 1 tab for the month. When February comes, I open this file, copy the January tab to a new tab, rename it February and populate the tab with February data. Then save the file under a new name. I now have 2 tabs, January & February. When March comes around, I do it again. This is fine through March. It seems that when I create the April tab, it becomes a problem. I even tried deleting the file and starting over with the March file again. But as soon as I create the April tab, the trace dependent function is gone. Also, “calculate” appears in the status bar. I have it set for automatic calculation. Even if I hit F9, it recalculates, but the status bar still says “calculate”. This didn’t bother me, but now that I see my trace dependent isn’t working, I’m concerned. I tried starting over a 3rd time and the same thing happened with the new file. It’s not happening with any other files I copy and update.

In another thread on this board it was suggested that the file size may be a problem. My file is fairly large, but I have files much larger and many more tabs where all the auditing tools work fine.

Thanks
Marnie