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?

Heres 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 didnt bother
me, but now that I see my trace dependent isnt working, Im concerned. I
tried starting over a 3rd time and the same thing happened with the new file.
Its not happening with any other files I copy and update. This file Im
working with is fairly large, but I have many larger files that I update the
same way and havent had any problems.

Thanks
Marnie