InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
Subscribe Login/Register
S&P 500
5,615.19
(
0.55%
)
US TECH 100
19,812.40
(
0.69%
)
Dow Jones
39,915.43
(
0.41%
)
Brent Oil
85.34
(
0.26%
)
Bitcoin
57,791.20
(
0.77%
)
Post# of 47150
Next 10
Reply Private New
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Qarel

Send PM Follow Ignore
Followers 1
Posts 321
Boards Moderated 0
Alias Born 01/30/2002

Qarel

Re: Conrad post# 1792

Friday, 03/15/2002 10:21:41 AM

Friday, March 15, 2002 10:21:41 AM

Post# of 47150
Conrad, while you are working on the circular reference problem, it might be good to know that there is a way to make Excel accept circular references. Just go to Tools\Options\Calculation(?) (Extra\Opties\Berekenen) and check Iteration (Iteratie). You probably won't need to change the iteration values.

To debug a circular reference, you select the problem cell and then you choose Tools\Check(?) (Extra\Controleren) and then the option to point to source and/or target cells.

Success!

Karel

Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Last Read Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.

Sign Up