Strange problem with linked Excel Tables error

[masplin]

Hi. I have Data model with 7 linked excel tables one of which is 750,000 lines. If I update all the smaller tables first, one by one, and then update the big table last i get an error "There were errors trying to update one or more linked tables etc" . Usually when this happens it is because there is a text entry in a date or number field. Sometimes its caused by some rogue duplication of a column that should have unique values so the relationship errors.

However after a day of searching for the above I tried just updating the tables the other way round, so large one first then the rest. Works perfectly!!!!!

Can anyone explain why if it isn't an actual incompatible data entry and none of the relationships are damaged i am getting this error. I just wasted so much time on it.

Thanks for any advice

Mike

 

[Tianbas]

Not sure if this is the same issue I have sometimes but I also have some errors in some of my files if I start updating a single table in the model although all data and relationships seem to be correct. This does not happen if I "refresh all" at the same time.

 

[masplin]

right as normally that's what I do. i only did it one at a time as we made some changes and owrried about the relationships breaking. Thought it was more controlled!!!!! So sounds like it's some usual MS b****t that actualyl makes no sense

thanks as good to know I'm not alone

Mike