Solved

Circular references

Posted on 2013-01-07
2
197 Views
Last Modified: 2013-01-07
Hi,

I have attached a file which has circular references (highlighted yellow)

Can someone explain why they are circular and/or amend the formula?

Thanks
Seamus
test.xlsx
0
Comment
Question by:Seamus2626
2 Comments
 
LVL 24

Accepted Solution

by:
Steve earned 500 total points
ID: 38750546
in cell G31, you have overwritten the querytable returned value with an =B13

this is the source of the circular reference and should go away after refresh of the table

if you wish to have values in G21:G39 then it may be better to paste values rather than use references.
0
 

Author Closing Comment

by:Seamus2626
ID: 38750569
Perfect!!

Thanks for that :-)
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question