ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Trace dependents is inactive (https://www.excelbanter.com/excel-discussion-misc-queries/34384-trace-dependents-inactive.html)

Rene

Trace dependents is inactive
 
Somehow in some of my Excel workbooks the function trace dependents is
inactive, while in other workbooks this function does work. I have no idea
why it does'nt work in those particular worksheets. Can anyone help?

Thanx,

Rene.

Robin Hammond

Rene,

It won't work if the sheet is protected. If that is not it, post back.

Robin Hammond
www.enhanceddatasystems.com

"Rene" wrote in message
...
Somehow in some of my Excel workbooks the function trace dependents is
inactive, while in other workbooks this function does work. I have no idea
why it does'nt work in those particular worksheets. Can anyone help?

Thanx,

Rene.





All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com