The jukebox musicals that work are the one where either the story and the music just gel or the ones based on the life of the artist or group like Buddy, Jersey Boys, Beautiful etc Going off-topic slightly, it's a shame some of the Bee Gees songs have already been used in Saturday Night Fever as I think a musical based on their life story would be interesting to watch although the Bee Gees have the good problem of having lots of songs which they wrote for themselves.
Abba may work because Abba produce dance music and strong tunes. The dance music may prove timeless, and obviously is a good start for a musical. . They also have a well written book for the musical - thats got humour, males in swimming cotumes and a mix of older and younger characters. WWRY works because several songs have become pop classics, known to most people, and there are sensational belt numbers. Its also got a decent book - which has an apt political message behind it, plus some very strong dance numbers. It also casts some of the top people around , and sometimes has more of them than most musicals.
Viva failed at most stages. the music could probably sustain a show - more easily if they included more solo works. The book though was all over the place. It raided Mamma Mia, and pre raided I Can't Sing. It developed parallel uneccessary stories, and then failed to develop most of them. It was hobbled by someone insisting that the link to the Spice Girls should be hidden - possibly to deal with the which spice Girl sings what issue. It was then weakened by the decision to cast unknowns as inexperienced looking beginners - which worked sadly too well. The workshop cast had stronger singers. You end up with the words and the music, but no story and none of the spirit, big performance numbers, or singer's characters, that could have made it more successful. The show that should have been just appeared in one last big performance number, in the finale. The story setting that should have been seems to have been taken for I can't sing. And whoever thought a Spice Girls musical shouldn't focus on the music, and a, spice girl like, band's story, should have been shown the door early on.