• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Circular Refrencing

P

Puneet

New Member
Hi All

This is my first post at chandoo.org. It's a wonderful portal to learn excel.

Question
I use MS Excel 2007. I have a very large sheet. Some rows are hidden also. Every Time I open the sheet I get circular referencing error. I tried to check all the formulas but I could not fix this problem. Can anyone help me in this?

Puneet
 
Hi Puneet,

Welcome to the forum.

Just check with this method where the excel is finding Circular Reference and try to resolve it.

On the Formulas tab, in the Formula Auditing group, click the arrow on the Error Checking in-group button, point to Circular References, and then click the first cell listed in the submenu. This will take you to the formula with Circular References.

Regards,
 
Hey Somendra

I tried again. There was a hidden cell. I fixed that cell. Now, there is no circular referencing.
 
You must log in or register to reply here.
Back
Top