Posted to microsoft.public.excel.misc

turbosteve turbosteve is offline

external usenet poster

Posts: 1

How do you initialize the values in a circular reference?

With complex calculations that require a circular reference, you can have an
error when you open the spreadsheet. It can be fixed by replacing a key value
in the reference to get the calculation going, then put the real calcuation
back in. This is cumbersome--how can you provide a way for the circular
reference calculations to start?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
circular reference	Sasa Stankovic	Excel Worksheet Functions	3	August 18th 08 03:58 PM
circular reference	circular reference	Excel Worksheet Functions	2	August 9th 08 10:05 PM
Circular reference	april	Excel Discussion (Misc queries)	3	September 16th 07 06:26 PM
Is this possible? (Circular reference?)	Big UT Fan	Excel Discussion (Misc queries)	2	July 11th 07 04:48 PM
Userform Initialize & combo box values	michaelberrier	Excel Discussion (Misc queries)	3	June 27th 06 04:35 PM

All times are GMT +1. The time now is 01:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us