Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / February 2008

Tip: Looking for answers? Try searching our database.

circular reference question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Georgeh - 12 Feb 2008 18:36 GMT
I am trying to calculate answers that use the answers from other
calculations. Is there a way to do that without getting errors?
Niek Otten - 12 Feb 2008 18:50 GMT
Please give details: formulas, values and results.

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am trying to calculate answers that use the answers from other
| calculations. Is there a way to do that without getting errors?
JLatham - 12 Feb 2008 20:30 GMT
As Niek has asked, it's probably a good thing to see the formulas you're using.

You CAN turn off the checks for circular references via:
Tools | Options | [Calculation] tab and check the Iterations option
This is rather dangerous thing to do because it will completely hide any
unintentional circular references you may either already have set up or may
set up in the future.

Quite often there is a solution that can be worked out that doesn't involve
a circular reference, and that is definitely more desirable - but to begin to
figure out such a solution, the formulas in use would have to be seen.

> I am trying to calculate answers that use the answers from other
> calculations. Is there a way to do that without getting errors?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.