To my knowledge you can not run a field calculation on fields that are from joined excel tables. This was based off of what I could gather from the web, and that when I try to field calculate on those fields it is simply grayed out.
So I have a field in my feature class (Let's say it is called " Field_FeatureClass " ) I am hoping I can field calculate using VB or Python scripts (If/else statements, etc.). I want to take in the corresponding cell value from the field belonging to the joined excel table (We will say it's called " Field_Excel " ) and translate that into a variable to use in an expression to then populate the corresponding cell in the field Field_FeatureClass.
I've had no luck thus far and I don't know if it's the way I'm setting up my expressions/statements, or if you simply can not pass in variables from a joined excel table to use in a field calculation/expression.