Newbie: relation not valid

[bluehenve]

• Hi
  Why is the relation not accepted in this example?
  https://www.dropbox.com/s/mdd4aamagmvoesd/kred.xlsx?dl=0
  
  Regards
  bluehenve
  
  
  
  

 

[Matt Allington]

I realise you couldn't post the link on the other forum, but you should only ask a question on a single forum, or cross link them at least. https://social.technet.microsoft.co...ation-not-valid?forum=sqlkjpowerpivotforexcel

 

[bluehenve]

You're right, sorry

 

[gazpage]

Power Pivot for Excel only allows one directional relationships that go from the one side to the many side. ie filters applied on the one side propagate to the other table but filters on the many side don't propagate to the one side.

I don't want to open a file off the internet, but could that be your problem?