You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
(Excel MVP Jan Karel Pieterse, our guest blogger, runs JKP Application Development Services, specializing in developing business solutions using Microsoft Excel/VBA and Access/VBA. )
There have been ample articles about troubleshooting unintentional circular references in Excel workbooks. This post focuses on the opposite: choosing to deliberately work with circular references.
Circular references aren't a bad thing in itself: you can use them to achieve complex calculations that are otherwise impossible to do, but first you must set them up properly.
Circular references can be useful in situations such as the following:
These are the most important things to consider when you create an Excel workbook with circular references:
If this high-level post has triggered your interest in circular references, let me invite you to head over to the article I posted on my website: Working with Circular references in Excel. In it I discuss the elements of using circular references in much more detail.
Jan Karel Pietersehttp://www.jkp-ads.com