Error in data table (what if analysis)

[simplyrohit]

I am finding the same result while calculating the data table of two variable. i crossed checked it number of times but m having the same problem. I think thrs a problem in the setting because its woring fine in the other worksheet but not working in a particular one. I would be really helpful if anybody can help...

[alansidman]

Will need more information to understand what your issue is. Perhaps an example with data of what is happening. How you are doing the calculations, etc. Your explanation is to vague to offer any assistance.

[simplyrohit]

Thanks for your reply..please post your email ID so i could forward you the file. It Would be better if you see that hand on hand.

[alansidman]

I don't work that way. If you want assistance, it must be done in the public forum, so all can learn and have the opportunity to help. Upload your file to this forum. Dummy up all confidential data. Run a compact and repair before uploading your file. Explain what you are seeking to do and what the expected results should be.

[simplyrohit]

I am new in this forum so didn't know much about it. Didn't knew how to upload. I tried to upload but not sure if its actually done.

[simplyrohit]

yes its done. Please go to valuation worksheet, scroll down, you will find a table in which all the values are same. but when i am doing it in other workbook the same data table works fine. I am not able to understand what is the problem.

[TMS]

The formulae on the Cost Metrics sheet are inconsistent on rows 18 and 19. You have introduced circular references in column I

I suggest that you fix those, and any others, before you try to pursue a solution.


Regards, TMS

[TMS]

In actual fact, there are dozens of circular references using AVERAGE and then propagating across a row.

[mike20009]

I am a new user to this forum. I have registered and activated my account via the link sent after signing up. Why can't I download any of the Excel files posted to these threads?

[TMS]

Welcome to the forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.