title: Auto Refresh referenced cell written with POI
body: <p>I have xlsx document with one sheet.<br>
  In cell 'A2' i have a reference to cell 'A1'.</p>
  
  <p>The following code writes data to cell 'A1'.  </p>
  
  <p>When I open the document, cell 'A2' is not updated with value of cell 'A1' automatically.<br>
  I am required to click on cell 'A2' and press enter, only then I see the new value.</p>
  
  <p>What can be done so when document is opened the value will be updated?</p>
  
  <pre><code>FileInputStream inputStream = null;
  FileOutputStream outputStream = null;
  XSSFWorkbook book = null;
  
  String path = "c://temp//doc.xlsx";
  
  inputStream = new FileInputStream(path);
  
  book = new XSSFWorkbook(inputStream);
  
  XSSFSheet sheet = book.getSheetAt(0);
  XSSFRow row = sheet.getRow(0);
  
  row.createCell(0).setCellValue("VALUE");
  
  outputStream = new FileOutputStream(path);
  
  book.write(outputStream);
  outputStream.close();
  </code></pre>