Microsoft Office Questions? Ask a IT Expert for Support ASAP
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
REMEMBER THAT JUST ANSWER IS A PAID SERVICE
to add the circular ref tool bar
on the top of the screen you have tabs
yes, I know that
hold a sec
let me open mine so I can give you step by step
Are we still connected?
ms moves everything around with every version
what you have to do to correct a circular reference in 2010
is find the cell that has the formula and change it
to do this click the formulas tab
there is a group for formula auditing
under there is a down arrow next to the word error checking
I would understand that to be reasonable. How do you find the circular reference? Another site says to install the cr toolbar.
you will see circular reference open
or i mean hover on it
and you will see a list of all of the cells that have circular references
there used to be a separate tool bar for it in office 2003
but they did away with it in later versions
did you get all of that?
or are you stuck?
I found it. Wow, how simple was that? That is why i prefer the plain old Quattro Pro
or lets go back to lotus 123
Thanks, XXXXX XXXXX you go onto something else but only aftrer i remember where the OK service button on this site.
think you have to leave chat to rate
i don't know where that is on your screen
got it. Thanks.
or say, I wish to Accept the Answer
and Ill have the site admins do it
sorry it still has not gone through yet