In Google Sheets, you cannot link two files (two separate spreadsheet documents) as easily as Excel but you do it through a function which imports a range of cells in a more secure way than Excel and it updates live. Use the function =IMPORTRANGE("file link","sheet name!Start cell:End cell"). Where you must physically type the special characters exactly as shown "!: but if something is written in the cell you don’t need to use speech marks " around it. I show what sort of things can go wrong as well and how to fix it.
