title: Generating QR code using Google API in Excel, the QR code is not generating on another spreadsheet in the same workbook
body: <p>I found this neat spreadsheet that will generate a QR code in excel via Google API.</p>
  
  <p>The website is below:
  <a href="https://sites.google.com/site/e90e50fx/home/generate-qrcode-with-excel" rel="nofollow noreferrer">https://sites.google.com/site/e90e50fx/home/generate-qrcode-with-excel</a></p>
  
  <p>The link to the downloadable spreadsheet is below:
  <a href="https://sites.google.com/site/e90e50fx/home/generate-qrcode-with-excel/qr_code_udf.xlsm?attredirects=0&amp;d=1" rel="nofollow noreferrer">https://sites.google.com/site/e90e50fx/home/generate-qrcode-with-excel/qr_code_udf.xlsm?attredirects=0&amp;d=1</a></p>
  
  <p>The issue I am having is that I copied the spreadsheet into another workbook.
  Initially it didn't work until I also copied the GoogleAPI module into that work book as well. The QR code will generate in the copied spreadsheet.
  However, what I am trying to do is generate the QR code in the same workbook but in another spreadsheet.</p>
  
  <p>It errors out.</p>
  
  <p>=URL_QRCode_SERIES("qr_code_1",J7:N7,,"qrCode")</p>
  
  <p>I am using this formula in the spreadsheet that I am trying to get the QR barcode image to generate in but it errors out and shows this error:</p>
  
  <p>#VALUE</p>
  
  <p>Can't figure out what is wrong.
  The value I am trying get a QR code for is using the concatenate command and it's in several merged cell columns as shown in formula above.</p>
  
  <p>It generates qr codes successfully for any other single cell column value in that spreadsheet. So I'm wondering if I need to change the formula.</p>