Spreadsheet: 294447d1391385440-how-to-edit-links-without-opening-all-workbooks-linked-to-a-file-the-beatles
Sheet: Sheet1

<table border="1">
<tbody>
<tr><th> | Song | </th><th> | Weeks on Hot 100 | </th><th> | Weeks On Top 40 | </th><th> | Weeks On Top 20 | </th><th> | Weeks in Top 10 | </th><th> | Weeks On Top 5 | </th><th> | Weeks at No.1 | </th><th> | Peak | </th><th> | Year | </th><th> | [NAME] | </th></tr>
<tr><td> | I Want To Hold Your Hand | </td><td> | 15 | </td><td> | 14 | </td><td> | 13 | </td><td> | 12 | </td><td> | 11 | </td><td> | 7 | </td><td> | 1 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | She Loves You | </td><td> | 15 | </td><td> | 14 | </td><td> | 12 | </td><td> | 11 | </td><td> | 9 | </td><td> | 2 | </td><td> | 1 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | Please Please Me | </td><td> | 13 | </td><td> | 10 | </td><td> | 8 | </td><td> | 7 | </td><td> | 5 | </td><td> | 0 | </td><td> | 3 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | I Saw Her Standing There | </td><td> | 11 | </td><td> | 8 | </td><td> | 3 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 14 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | My [NAME] | </td><td> | 6 | </td><td> | 2 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 26 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | From Me To You | </td><td> | 6 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 41 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | Twist And Shout | </td><td> | 26 | </td><td> | 16 | </td><td> | 9 | </td><td> | 7 | </td><td> | 5 | </td><td> | 0 | </td><td> | 2 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | Roll Over Beethoven | </td><td> | 4 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 68 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | Can't Buy Me Love | </td><td> | 10 | </td><td> | 9 | </td><td> | 7 | </td><td> | 6 | </td><td> | 6 | </td><td> | 5 | </td><td> | 1 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | All My Loving | </td><td> | 6 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 45 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | Do You Want To Know A Secret | </td><td> | 11 | </td><td> | 9 | </td><td> | 8 | </td><td> | 5 | </td><td> | 5 | </td><td> | 0 | </td><td> | 2 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | You Can't Do That | </td><td> | 4 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 48 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | Thank You Girl | </td><td> | 7 | </td><td> | 3 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 35 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | There's A Place | </td><td> | 1 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 74 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | Love Me Do | </td><td> | 14 | </td><td> | 11 | </td><td> | 9 | </td><td> | 6 | </td><td> | 5 | </td><td> | 1 | </td><td> | 1 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | Why | </td><td> | 1 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 88 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | PS I Love You | </td><td> | 8 | </td><td> | 7 | </td><td> | 4 | </td><td> | 1 | </td><td> | 0 | </td><td> | 0 | </td><td> | 10 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | Four By The Beatles | </td><td> | 3 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 92 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | Sie Liebt Dich | </td><td> | 1 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 97 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | A Hard Day's Night | </td><td> | 13 | </td><td> | 12 | </td><td> | 10 | </td><td> | 8 | </td><td> | 6 | </td><td> | 2 | </td><td> | 1 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | Ain't She Sweet | </td><td> | 9 | </td><td> | 7 | </td><td> | 1 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 19 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | I Should Have Known Better | </td><td> | 4 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 53 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | And I Love Her | </td><td> | 9 | </td><td> | 7 | </td><td> | 4 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 12 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | I'll Cry Instead | </td><td> | 7 | </td><td> | 5 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 25 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | If I Fell | </td><td> | 9 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 53 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | I'm Happy Just To Dance With You | </td><td> | 1 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 95 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | Matchbox | </td><td> | 8 | </td><td> | 5 | </td><td> | 3 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 17 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | [NAME] | </td><td> | 7 | </td><td> | 4 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 25 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | I Feel Fine | </td><td> | 11 | </td><td> | 11 | </td><td> | 8 | </td><td> | 7 | </td><td> | 7 | </td><td> | 3 | </td><td> | 1 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | She's A Woman | </td><td> | 9 | </td><td> | 8 | </td><td> | 6 | </td><td> | 2 | </td><td> | 2 | </td><td> | 0 | </td><td> | 4 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | Eight Days A Week | </td><td> | 10 | </td><td> | 9 | </td><td> | 8 | </td><td> | 5 | </td><td> | 4 | </td><td> | 2 | </td><td> | 1 | </td><td> | 1964 | </td><td> |  | </td></tr>
<tr><td> | I Don't Want To Spoil The Party | </td><td> | 6 | </td><td> | 1 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 39 | </td><td> | 1965 | </td><td> |  | </td></tr>
<tr><td> | 4 - By The Beatles | </td><td> | 5 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 68 | </td><td> | 1965 | </td><td> |  | </td></tr>
<tr><td> | Ticket To Ride | </td><td> | 11 | </td><td> | 9 | </td><td> | 9 | </td><td> | 6 | </td><td> | 5 | </td><td> | 1 | </td><td> | 1 | </td><td> | 1965 | </td><td> |  | </td></tr>
<tr><td> | Yes It Is | </td><td> | 4 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 46 | </td><td> | 1965 | </td><td> |  | </td></tr>
<tr><td> | Help! | </td><td> | 13 | </td><td> | 12 | </td><td> | 9 | </td><td> | 6 | </td><td> | 6 | </td><td> | 3 | </td><td> | 1 | </td><td> | 1965 | </td><td> |  | </td></tr>
<tr><td> | Yesterday | </td><td> | 11 | </td><td> | 9 | </td><td> | 8 | </td><td> | 6 | </td><td> | 6 | </td><td> | 4 | </td><td> | 1 | </td><td> | 1965 | </td><td> |  | </td></tr>
<tr><td> | Act Naturally | </td><td> | 7 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 47 | </td><td> | 1965 | </td><td> |  | </td></tr>
<tr><td> | We Can Work It Out | </td><td> | 12 | </td><td> | 11 | </td><td> | 9 | </td><td> | 7 | </td><td> | 7 | </td><td> | 3 | </td><td> | 1 | </td><td> | 1965 | </td><td> |  | </td></tr>
<tr><td> | Day Tripper | </td><td> | 10 | </td><td> | 8 | </td><td> | 5 | </td><td> | 3 | </td><td> | 1 | </td><td> | 0 | </td><td> | 5 | </td><td> | 1965 | </td><td> |  | </td></tr>
<tr><td> | Nowhere Man | </td><td> | 9 | </td><td> | 9 | </td><td> | 7 | </td><td> | 5 | </td><td> | 2 | </td><td> | 0 | </td><td> | 3 | </td><td> | 1966 | </td><td> |  | </td></tr>
<tr><td> | What Goes On | </td><td> | 2 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 81 | </td><td> | 1966 | </td><td> |  | </td></tr>
<tr><td> | Paperback Writer | </td><td> | 10 | </td><td> | 10 | </td><td> | 8 | </td><td> | 5 | </td><td> | 4 | </td><td> | 2 | </td><td> | 1 | </td><td> | 1966 | </td><td> |  | </td></tr>
<tr><td> | Rain | </td><td> | 7 | </td><td> | 5 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 23 | </td><td> | 1966 | </td><td> |  | </td></tr>
<tr><td> | [NAME] | </td><td> | 9 | </td><td> | 8 | </td><td> | 7 | </td><td> | 6 | </td><td> | 4 | </td><td> | 0 | </td><td> | 2 | </td><td> | 1966 | </td><td> |  | </td></tr>
<tr><td> | [NAME] | </td><td> | 8 | </td><td> | 6 | </td><td> | 3 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 11 | </td><td> | 1966 | </td><td> |  | </td></tr>
<tr><td> | [NAME] Forever | </td><td> | 9 | </td><td> | 7 | </td><td> | 5 | </td><td> | 1 | </td><td> | 0 | </td><td> | 0 | </td><td> | 8 | </td><td> | 1967 | </td><td> |  | </td></tr>
<tr><td> | [NAME] | </td><td> | 10 | </td><td> | 9 | </td><td> | 6 | </td><td> | 5 | </td><td> | 4 | </td><td> | 1 | </td><td> | 1 | </td><td> | 1967 | </td><td> |  | </td></tr>
<tr><td> | All You Need Is Love | </td><td> | 11 | </td><td> | 9 | </td><td> | 7 | </td><td> | 7 | </td><td> | 5 | </td><td> | 1 | </td><td> | 1 | </td><td> | 1967 | </td><td> |  | </td></tr>
<tr><td> | Baby You're A Rich Man | </td><td> | 5 | </td><td> | 2 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 34 | </td><td> | 1967 | </td><td> |  | </td></tr>
<tr><td> | Hello Goodbye | </td><td> | 11 | </td><td> | 10 | </td><td> | 9 | </td><td> | 8 | </td><td> | 6 | </td><td> | 3 | </td><td> | 1 | </td><td> | 1967 | </td><td> |  | </td></tr>
<tr><td> | I Am The Walrus | </td><td> | 4 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 56 | </td><td> | 1967 | </td><td> |  | </td></tr>
<tr><td> | [NAME] | </td><td> | 11 | </td><td> | 10 | </td><td> | 8 | </td><td> | 7 | </td><td> | 3 | </td><td> | 0 | </td><td> | 4 | </td><td> | 1968 | </td><td> |  | </td></tr>
<tr><td> | The Inner Light | </td><td> | 1 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 96 | </td><td> | 1968 | </td><td> |  | </td></tr>
<tr><td> | Hey Jude | </td><td> | 19 | </td><td> | 19 | </td><td> | 16 | </td><td> | 14 | </td><td> | 12 | </td><td> | 9 | </td><td> | 1 | </td><td> | 1968 | </td><td> |  | </td></tr>
<tr><td> | Revolution | </td><td> | 11 | </td><td> | 11 | </td><td> | 9 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 12 | </td><td> | 1968 | </td><td> |  | </td></tr>
<tr><td> | Get Back | </td><td> | 12 | </td><td> | 12 | </td><td> | 11 | </td><td> | 9 | </td><td> | 7 | </td><td> | 5 | </td><td> | 1 | </td><td> | 1969 | </td><td> |  | </td></tr>
<tr><td> | Don't Let Me Down | </td><td> | 4 | </td><td> | 3 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 35 | </td><td> | 1969 | </td><td> |  | </td></tr>
<tr><td> | The Ballad Of John And Yoko | </td><td> | 9 | </td><td> | 8 | </td><td> | 6 | </td><td> | 4 | </td><td> | 0 | </td><td> | 0 | </td><td> | 8 | </td><td> | 1969 | </td><td> |  | </td></tr>
<tr><td> | [NAME] | </td><td> | 6 | </td><td> | 6 | </td><td> | 5 | </td><td> | 4 | </td><td> | 2 | </td><td> | 0 | </td><td> | 2 | </td><td> | 1969 | </td><td> |  | </td></tr>
<tr><td> | Something | </td><td> | 16 | </td><td> | 16 | </td><td> | 14 | </td><td> | 8 | </td><td> | 5 | </td><td> | 1 | </td><td> | 1 | </td><td> | 1969 | </td><td> |  | </td></tr>
<tr><td> | Let It Be | </td><td> | 14 | </td><td> | 13 | </td><td> | 11 | </td><td> | 11 | </td><td> | 8 | </td><td> | 2 | </td><td> | 1 | </td><td> | 1970 | </td><td> |  | </td></tr>
<tr><td> | The Long And Winding Road | </td><td> | 10 | </td><td> | 10 | </td><td> | 8 | </td><td> | 6 | </td><td> | 4 | </td><td> | 2 | </td><td> | 1 | </td><td> | 1970 | </td><td> |  | </td></tr>
<tr><td> | Got To Get You Into My Life | </td><td> | 16 | </td><td> | 11 | </td><td> | 8 | </td><td> | 5 | </td><td> | 0 | </td><td> | 0 | </td><td> | 7 | </td><td> | 1976 | </td><td> |  | </td></tr>
<tr><td> | Ob La Di Ob La Da | </td><td> | 7 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 49 | </td><td> | 1976 | </td><td> |  | </td></tr>
<tr><td> | Sgt Pepper's Lonely Hearts Club Band | </td><td> | 7 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 71 | </td><td> | 1978 | </td><td> |  | </td></tr>
<tr><td> | The Beatles Movie Medley | </td><td> | 11 | </td><td> | 8 | </td><td> | 6 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 12 | </td><td> | 1982 | </td><td> |  | </td></tr>
<tr><td> | Baby It's You | </td><td> | 4 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 67 | </td><td> | 1995 | </td><td> |  | </td></tr>
<tr><td> | Free As A Bird | </td><td> | 11 | </td><td> | 4 | </td><td> | 3 | </td><td> | 2 | </td><td> | 0 | </td><td> | 0 | </td><td> | 6 | </td><td> | 1995 | </td><td> |  | </td></tr>
<tr><td> | Real Love | </td><td> | 7 | </td><td> | 3 | </td><td> | 1 | </td><td> | 0 | </td><td> | 0 | </td><td> | 0 | </td><td> | 11 | </td><td> | 1996 | </td><td> |  | </td></tr>
</tbody> | </table>