title: Linking one google docs spreadsheet to another maximum 50 reference allowed ?? I have More Than 500 Hundred
body: <p>I used the following approach from <a href="https://stackoverflow.com/a/14009201/">this answer</a>:</p>
  
  <blockquote>
    <p>First go to the spreadsheet that you want to import the data from
    <code>(docA)</code> and observe the value of the key mentioned in the URL (Eg:
    <a href="https://docs.google.com/spreadsheet/ccc?key=ABC#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheet/ccc?key=ABC#gid=0</a>, in this case
    the key is <code>ABC</code>).</p>
    
    <p>Now go to the cell in <code>docB</code> and use the <code>importRange</code> function to
    import the data.</p>
  
  <pre><code>=importRange(, !:)
  
  Eg: =importRange("ABC", "Sheet1!A1:B10")
  </code></pre>
    
    <p>If you want to import just one cell: E.g. <code>=importRange("ABC",
    "Sheet1!A1");</code></p>
    
    <p>If you don't mention the name of the sheet, the first sheet is used.</p>
  </blockquote>
  
  <p>it was very helpful
  i used this featured and Google prompted a notification that</p>
  
  <p>There was a problem
  At this time, spreadsheets in Google Sheets only support up to 50 ImportRange functions in a single spreadsheet.</p>
  
  <p>Any Solution ???</p>