| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to trace dependents and file shows "Calculate" all the time
Hi guys! Hope you can help me out on these 2 issues:-
1) Tracing dependents I used to be able to trace dependents across the worksheets on the Excel model that i am maintaining, and now i can no longer do so! It returns the message "The trace dependents command found no formulas that refer to the active cell". Yikes! Is there a fix for this? 2) Calculate Regardless of the number of times the workbook has been calculated, it still shows "Ready Calculate" instead of just "Ready". Is there a reason for this and how can i overcome this? Really appreciate any advice! Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
| Excel's file name incorrectly shows ":" and a number for # of shee | Excel Discussion (Misc queries) | |||
| Status Bar Shows "CALCULATE" | Excel Worksheet Functions | |||
| unable to hide columns -"can not shift objects off sheet" shows | Excel Worksheet Functions | |||
Threaded Mode
