View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Seagal Seagal is offline
external usenet poster
 
Posts: 2
Default 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!