Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
irfan
 
Posts: n/a
Default Formula Audit toolbar

Hi,

I would appreciate it if someone can tell me if there is any reason why
I cannot use this toolbar. When I am in a certain cell and I use the
trace dependent or precedent buttons, nothing occurs. I have
successfully used this command on my last computer to check formulas. I
would very much appreciate any advice.

thanks.

Irfan

  #2   Report Post  
bj
 
Posts: n/a
Default

I can't tell if it works in some cells but not in others. If it doesn't work
on any, especially cells you have put the equation in yourself. YOU probably
need to reinstall Excel.
If it works on some, check to see if cells where it doesn't work would
fall into the catagorys listed in the help section in
"Troubleshoot tracing dependent, precedent, and error cells"


"irfan" wrote:

Hi,

I would appreciate it if someone can tell me if there is any reason why
I cannot use this toolbar. When I am in a certain cell and I use the
trace dependent or precedent buttons, nothing occurs. I have
successfully used this command on my last computer to check formulas. I
would very much appreciate any advice.

thanks.

Irfan


  #3   Report Post  
irfan
 
Posts: n/a
Default

Hi,

Thanks for the quick response. The command does not work at all on any
cells, even on newly created worksheets. Is there an option that needs
to be turned on or is installing the entire program the only option.

thanks.

Irfan

  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

Irfan

I would try to reset the Toolbar before anything else as drastic as
re-installation.

ToolsCustomizeToolbars.

Scroll down to the Formula Auditng toolbar.

Select but do not checkmark then hit the "reset" button.


Gord Dibben Excel MVP

On 10 May 2005 11:01:53 -0700, "irfan" wrote:

Hi,

Thanks for the quick response. The command does not work at all on any
cells, even on newly created worksheets. Is there an option that needs
to be turned on or is installing the entire program the only option.

thanks.

Irfan


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
Howdo U copy a formula down a column, that uses data in another w. Need Help pasting a formula Excel Worksheet Functions 1 February 25th 05 06:04 PM
Howdo U copy a formula down a column, that uses data in another w. brantty Excel Worksheet Functions 0 February 25th 05 10:11 AM
Problem with VBA returning the contents of a long formula. [email protected] Excel Discussion (Misc queries) 2 February 23rd 05 12:14 AM
Formula Result Correct but value in the cell is wrong jac Excel Worksheet Functions 2 December 17th 04 08:05 PM
How do I use Range Names listed in a VLookup table in a formula? Essbasedvlpr32 Excel Worksheet Functions 3 December 15th 04 10:11 PM


All times are GMT +1. The time now is 05:24 PM.

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

About Us

"It's about Microsoft Excel"