Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 23rd 07, 06:16 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 16
Default trace dependent tool doesn't work but trace precendent doesn't

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?

Here’s 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 didn’t bother
me, but now that I see my trace dependent isn’t working, I’m concerned. I
tried starting over a 3rd time and the same thing happened with the new file.
It’s not happening with any other files I copy and update. This file I’m
working with is fairly large, but I have many larger files that I update the
same way and haven’t had any problems.

Thanks
Marnie

  #2   Report Post  
Old May 23rd 07, 06:34 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,440
Default trace dependent tool doesn't work but trace precendent doesn't

Hi Marnie,

Try CTRL+SHIFT+ALT+F9 (rebuild dependency tree). Works only in later versions of Excel (I don't remember from which one).
Alternative: Find and Replace = by = (equal sign replaces equals sign) for all sheets

Post again in this thread if that doesn't help.

BTW one of the reasons for the Calculate message can be that there are more than 65536 dependencies. Is there any chance that is
the case in your workbook?
It causes Excel to ignore the dependencies for recalculation, maybe also for the trace tool.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"marnie" wrote in message ...
| 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?
|
| Here's 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 didn't bother
| me, but now that I see my trace dependent isn't working, I'm concerned. I
| tried starting over a 3rd time and the same thing happened with the new file.
| It's not happening with any other files I copy and update. This file I'm
| working with is fairly large, but I have many larger files that I update the
| same way and haven't had any problems.
|
| Thanks
| Marnie


  #3   Report Post  
Old May 24th 07, 12:26 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 16
Default trace dependent tool doesn't work but trace precendent doesn't

Thanks Niek, and yes, I probably have more than 65,536 dependencies. Each
tab has 35 columns of lookup formulas. That would explain why this wasn't a
problem when I had 3 tabs, but as soon as make a 4th tab, it's a problem. I
have an older version of Excel, but I'll try each of the things you
mentioned. I do feel more comfortable that I don't have a virus. I may just
have to live without the ability to use the trace dependent.
Thanks again
Marnie

"Niek Otten" wrote:

Hi Marnie,

Try CTRL+SHIFT+ALT+F9 (rebuild dependency tree). Works only in later versions of Excel (I don't remember from which one).
Alternative: Find and Replace = by = (equal sign replaces equals sign) for all sheets

Post again in this thread if that doesn't help.

BTW one of the reasons for the Calculate message can be that there are more than 65536 dependencies. Is there any chance that is
the case in your workbook?
It causes Excel to ignore the dependencies for recalculation, maybe also for the trace tool.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"marnie" wrote in message ...
| 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?
|
| Here's 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 didn't bother
| me, but now that I see my trace dependent isn't working, I'm concerned. I
| tried starting over a 3rd time and the same thing happened with the new file.
| It's not happening with any other files I copy and update. This file I'm
| working with is fairly large, but I have many larger files that I update the
| same way and haven't had any problems.
|
| Thanks
| Marnie





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Q about trace dependent to worksheet icon [email protected] Excel Discussion (Misc queries) 0 July 10th 06 05:53 PM
Trace Dependents Trot Excel Discussion (Misc queries) 1 May 24th 06 05:55 PM
Trace Dependent Cells of the Linked Files [email protected] Excel Discussion (Misc queries) 1 March 7th 06 01:53 AM
Trace Dependants NICK Excel Discussion (Misc queries) 0 May 18th 05 08:16 AM
Trace ALL dependent cells in any worksheet anywhere in Excel Graham Tapper Excel Worksheet Functions 6 March 11th 05 05:44 PM


All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017