Having problems with circular references in complex financial
spreedsheets. Can anyone suggest a good way of dealing with them and
techniques to eliminate them. I have read the microsoft help, but it
doesn't help me improve the design of the spreadsheet.

Thanks in advance

Alex

Not an expert (XL2k) and have only used the functions to see what they'd
do but:
Under "Tools->Auditing" there are some tools such as "Trace Precedents,
Trace Dependants" etc that will show you what each formula is looking
at.
I've not used them because typically my Worksheets aren't that complex
and it's relatively easy to find the error of my ways,
summing a column and including the formula cell in the list, for ex.


--
Regards;
Rob
------------------------------------------------------------------------
"Alex" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Having problems with circular references in complex financial
> spreedsheets. Can anyone suggest a good way of dealing with them and
> techniques to eliminate them. I have read the microsoft help, but it
> doesn't help me improve the design of the spreadsheet.
>
> Thanks in advance
>
> Alex

You can also use the Circular reference Toolbar. If you don't see it, then hit
View / Toolbars / Customise and select it.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"RWN" <(E-Mail Removed)> wrote in message
news:O7b$(E-Mail Removed)...
> Not an expert (XL2k) and have only used the functions to see what they'd
> do but:
> Under "Tools->Auditing" there are some tools such as "Trace Precedents,
> Trace Dependants" etc that will show you what each formula is looking
> at.
> I've not used them because typically my Worksheets aren't that complex
> and it's relatively easy to find the error of my ways,
> summing a column and including the formula cell in the list, for ex.
>
>
> --
> Regards;
> Rob
> ------------------------------------------------------------------------
> "Alex" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Having problems with circular references in complex financial
> > spreedsheets. Can anyone suggest a good way of dealing with them and
> > techniques to eliminate them. I have read the microsoft help, but it
> > doesn't help me improve the design of the spreadsheet.
> >
> > Thanks in advance
> >
> > Alex
>
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004