LinkBack URL
About LinkBacks
I have been working on a timesheet for my staff and I am getting a circular reference error which I can't get rid of. can anyone help?
I have been working on a timesheet for my staff and I am getting a circular reference error which I can't get rid of. can anyone help?
Hi,
In the formula's tab, under formula auditing you can find where your circular errors are under error checking.
Looks like yours is on sheet "30 Apr-13 May" in cell E20 which is referencing itself.
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
Welcome to the Excel Help Forum.
TIP: one of the best, but probably under-utilized, features is the Evaluate Formula tool. Ribbon Menu >Formulas > Evaluate Formula
It will step you thru the formula so that can see how Excel resolves each argument and cell reference and can help to pinpoint errors.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
thanks spitfireblue for having a look for me,
i can't see the sheet that you are talking about "30 Apr-13 May"
It is a hidden sheet in your workbook
thanks for your help, once i found the hidden file the problem was fixed. i shoulder of look.
thank you
While that is indeed a good way to ID where the circ ref is, it is not always that reliable. If the circ ref has been there for a while and you have added many more formulas, the CR may reference an error way further up the calc chain, necessitating deleting the cell (or range) that is pointed to, then the next cell/range etc until the error is finally removed. Make a note of the last deletion/correction, then UnDo all your changes, go back to that lasat fix and correct itOriginally Posted by spitfireblue
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
While that is indeed a good way to ID where the circ ref is, it is not always that reliable. If the circ ref has been there for a while and you have added many more formulas, the CR may reference an error way further up the calc chain, necessitating deleting the cell (or range) that is pointed to, then the next cell/range etc until the error is finally removed. Make a note of the last deletion/correction, then UnDo all your changes, go back to that lasat fix and correct it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks