title: IMPORTRANGE function not refreshing new entries in linked Google sheet
body: <p>My IMPORTRANGE function is not refreshing with new data once the linked spreadsheet is added to. Instead, I am having to cut and paste all of the formulae again whenever I want to view the new information.</p>
  
  <p>I'm using the new version of Google Sheets and I know there were some issues around the release of this with the IMPORTRANGE function. </p>
  
  <p>I currently have 24 columns of data that I'm importing and the original spreadsheet will just keep growing as it is linked to a form. This is the main reason I'm using IMPORTRANGE, as it will help to keep the original spreadsheet working at maximum speed.</p>
  
  <p>What I'd like to know is, has anyone else had a problem such as this, and if so is there any work around (in apps script/another function)? In worst case scenario, is there an apps script about which would clear the spreadsheet and re-enter all of the formulae on open/on a menu click as it really is a pain updating every column every time a new entry is made.</p>
  
  <p><strong>EDIT -</strong> Almost all of the cells I'm trying to import are formulated within the original spreadsheet if that changes anything <strong>- EDIT</strong></p>