Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trace Dependents
The trace dependents audit command is not working properly in my file. The
function works sometimes within a worksheet but never works when tracing calculations between worksheets. My file is 17.4 MB and the word 'Calculate' is present in the lower gray task bar. Does anyone know what is causing this and/or how to fix it? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trace Dependents
If you're using Excel 2003 the dependecy line will show a worksheet icon, and
when you double click on the line it will open the goto box with the name of the worksheet the cell is linked to. As for the Calc message on the status bar, you recalculation method is set to manual, and given the size of your file that's understandable. Press F9 to update your formula values, but you might also want to take lunch as well. To turn manual recalc off, click TOOLS in the menu, select OPTIONS and click the CALCULATION tab. The first option button on the page will reset it back to automatic. Keep in mind that everytime you enter a value, all formulas will recalc. -- Kevin Backmann "Trot" wrote: The trace dependents audit command is not working properly in my file. The function works sometimes within a worksheet but never works when tracing calculations between worksheets. My file is 17.4 MB and the word 'Calculate' is present in the lower gray task bar. Does anyone know what is causing this and/or how to fix it? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to trace dependents across worksheets? | Excel Discussion (Misc queries) | |||
Trace Precedents and Dependents Arrows are Invisible | Excel Discussion (Misc queries) | |||
how do trace dependents for all cells at once? | Excel Discussion (Misc queries) | |||
Trace dependents not working | Excel Discussion (Misc queries) | |||
Trace Dependents and Precedents not working | Excel Worksheet Functions |