Posted to microsoft.public.excel.misc

Elliot

external usenet poster

Posts: 17

data tables and intentional circular references

I have a cash flow model that utilizes circular references and iterations to
work. It seems to function okay. When I combine it with data tables, however,
the model breaks down and I get lots of #NA errors, I think because of the
multiple iterations. I can fix the model easily, but the same error occurs
whenever I calculate (F9) the data tables. Any thoughts?

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 references	Dave F	Excel Discussion (Misc queries)	0	March 28th 07 03:06 AM
circular references	[email protected]	Excel Discussion (Misc queries)	0	March 28th 07 01:20 AM
Those Circular References...	JeremyH1982	Excel Discussion (Misc queries)	4	May 22nd 06 10:51 PM
Circular references	R.Hocking	Excel Worksheet Functions	1	February 2nd 06 06:51 PM
Help :Circular References	PPT	Excel Worksheet Functions	1	January 29th 06 03:20 PM

All times are GMT +1. The time now is 04:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us