Can't seem to fix my #REF! error to link sheets

[Jack-P-Winner]

I am getting a #REF! error in a couple games. Game 45,46 and 47. I was able to fix the others but can not seem to figure out what I am missing. I know someone here can tell me (-:

https://www.dropbox.com/s/r4wvytcwodw3vm2/Game41_NumbersInput_MOD.xlsm

https://www.dropbox.com/s/2m201zt3f5nbmng/#REF!.jpg

If you go to the Drawn Numbers Tab, last to the left and click on Conditional Formatting and then LnK in the pull down you can see the error


Thank you all!!!!!!

 

[Hui]

Jack

The CF manager is dependent on which cell you are in when you open the CF Manager
So i can't see any CF errors
Can you please be more specific about which cell you are concerned about

As a suggestion you may want to check the ranges that then CF apply to
Eg: If I goto T17 and open the CF manager
Then click into one of the ranges in Applies To column of the the manager
You will see the ranges highlighted by the flashing dashed lines
Please notice that there are several inconsistencies with the ranges shapess

Generally #REF! errors mean that a cell/range refereed to by a formula has been deleted or removed

 

[Jack-P-Winner]

If you go to game 45 cell A32 and A35 have the error. hmmm you are right come to think of it. A7 is missing now or got deleted some how hmmm BUT the other cells work fine that are from A and I can not seem to find it. If I go to numbers drawn page and click on cell C7 data is there for B7 but no A hmmmm

 

[Jack-P-Winner]

I fixed this one last night. I ha to put in a dummy code to bypass the A cell to make it True

Thanks Hui