title: Formula Evaluator in Apache POI
body: <p>I have a program in which it pulls data from a workbook. One of the sheets has a cell in it that gets its data from a formula that involves another sheet from the same workbook. The workbook is called "week 11.xls" and the sheet is called Sat AP. I'm trying to use this code below:</p>
  
  <pre><code>    HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(myWorkbook);
      HSSFCell cell = myWorkbook.getSheetAt(11).getRow(10).getCell(3); 
      CellValue cv = fe.evaluate(cell);
  </code></pre>
  
  <p>I get the error that it cannot resolve the external workbook week 11 sat.xls It seems as if it is trying to open week 11 sat.xls when it should be trying to open week 11.xls. myWorkbook is used it other functions and it works fine so I know that it is not pointing to the wrong file. Any help would be much appreciated. Thanks!</p>