please send example file.
and please explain what you are trying to do.
It gets very picky trying to indirect another workbook.
which of the workbooks you provided is the circular reference one, and which cell is the formula in?
i need playerstats.xls to test
there is a link to that file
ok, so what is happening is you are using the value in column A to vlookup and populate the value in column C. And then the indirect reference in column A references back to column C. Do you see the problem?
ok, your right
let me check something else
ok, i am not getting a cicular error, I am getting something totally different
first things first the file names are ***** ***** upper case, and you do not have upper case in the cell that is refered to in the formula, if you use the UPPER() function in your formula for cell c1, c23 and so on. or change the file names so they match. that should help.
Let me know if that fixes anything
so maybe the files got renames when they were uploaded, maybe they got changed to upper case there,.
Im using excel 2010, so maybe it treats things a bit differently..
this is what I am getting.
am i supposed to be getting something different.
i don't think the version is at issue.
It may be your OS and your excel.
We may need to set up a remote session.
But if you want to work with someone else that is fine, they are just going to tell you the same thing.
yes I can handle it if I can see the error. lool, this is why I reccomend remote.
teamviewer i believe there is a mac version
sorry the site always charges extra for remote support.
i may just opt out, and let someone else take over. Since you don't seam confortable with this option
and I wish i could recreate the error, but I can't so that only leaves one option. remote.
version, is not the issue.
but I am going to open your question to the pool of people here, because we do not seam to be on the same page here, and there is no point in spending any more time if you don't wish to pay for the remote service.
someone should be along soon
Hello, this is Bing and I am reviewing your question.
Just downloaded. Please bear with me for a while because I got a meeting in 20 mins so I can't be available very soon. Will advise once all files have been reviewed. Thanks.
You are welcome.
NO! But I am sorry still in meetings away from my Mac. I will review your questions once get back to my Mac. No worries.
Or, if you do prefer, I may opt out for now. If I am available again and no other experts working on it, I will opt in again. Be aware that the question value may increase a bit this way. Is it okay for you?
Sorry again. I will finalize your question in two hours. Is it convenient for you today?
Are you seeing the same thing on your Excel for Mac?
I can't see that.
What's your Excel version? I am using Excel for Mac 2011. I also cross verified your spreadsheet with Excel 2010 on Windows 7. The same thing.
Mine is 14.6.9, a bit higher but I don't think it makes sense.
I reckon it is caused by settings. Bear with me for a moment.
Check your settings and compare with my screenshot. Make sure Formula tab is in use.
The issue is in Column B, not A.
What do you expect to get $C$82 or $D$82?
FYI - There is no any errors on Excel 2010 at all. Please see attached the screenshot.
This does indicate a version difference issue, though initially I didn't think it could be a problem. Therefore I do suggest you to patch your Office for Mac to the latest version, then troubleshoot again and see if the error persists.
You know, it is not worth it spending hours on troubleshooting issues caused by a bug or defect of MS products. :-)
Any update please?
Hello? Did you try updating your Office for Mac? There was a recent update last week.
How about the issue? No longer a problem?