Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I solve circular references?
I have a circular reference in a sheet and when i want to link cells to
different sheets, the value is coming up as zero. I do not want to copy and paste the values because if i make a change on the sheet i want it to be reflected on the subsequent formulae. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I solve circular references?
If the circular reference toolbar is not visible, click VIEW in the menu,
select TOOLBARS and then click CIRCULAR REFERENCE. The first object on the CIRCULAR REFERENCE toolbar is the NAVIGATE CIRCULAR REFERENCES combo box, which show as list of cells containing a circular reference. Drop down the list and select the cell which has the cicular reference and edit the formula to resolve the conflict. A circular reference is a cell reference in a formula that references its own location. If you type in the formula =SUM(A1:A10) in cell A10, that will generate a circular reference. -- Kevin Backmann "Amy Ryan" wrote: I have a circular reference in a sheet and when i want to link cells to different sheets, the value is coming up as zero. I do not want to copy and paste the values because if i make a change on the sheet i want it to be reflected on the subsequent formulae. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I solve circular references?
If you have trouble finding the circular reference, maybe Stephen Bullen's
utility will help: http://www.oaltd.co.uk/Excel/Default.htm Look for FindCirc.zip Amy Ryan wrote: I have a circular reference in a sheet and when i want to link cells to different sheets, the value is coming up as zero. I do not want to copy and paste the values because if i make a change on the sheet i want it to be reflected on the subsequent formulae. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I solve circular references?
Thanks Dave-circular ref solver looks very helpful. Do you know if there is
any way I can import this box into another spreadsheet?? "Dave Peterson" wrote: If you have trouble finding the circular reference, maybe Stephen Bullen's utility will help: http://www.oaltd.co.uk/Excel/Default.htm Look for FindCirc.zip Amy Ryan wrote: I have a circular reference in a sheet and when i want to link cells to different sheets, the value is coming up as zero. I do not want to copy and paste the values because if i make a change on the sheet i want it to be reflected on the subsequent formulae. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I solve circular references?
That addin is not part of any other workbook. If you have it running in excel,
it'll be available to all workbooks. Check near the bottom of the Tools menu to start it. Amy Ryan wrote: Thanks Dave-circular ref solver looks very helpful. Do you know if there is any way I can import this box into another spreadsheet?? "Dave Peterson" wrote: If you have trouble finding the circular reference, maybe Stephen Bullen's utility will help: http://www.oaltd.co.uk/Excel/Default.htm Look for FindCirc.zip Amy Ryan wrote: I have a circular reference in a sheet and when i want to link cells to different sheets, the value is coming up as zero. I do not want to copy and paste the values because if i make a change on the sheet i want it to be reflected on the subsequent formulae. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Those Circular References... | Excel Discussion (Misc queries) | |||
Removing circular references without the use of macros? | Excel Discussion (Misc queries) | |||
Frequnecy Circular References | Excel Discussion (Misc queries) | |||
Help solve a Circular Reference | Excel Worksheet Functions | |||
Why do multiple circular references affect each other in a worksh. | Excel Discussion (Misc queries) |