PHPExcel can't read calculated value from different spreadsheet
<p>I am using PHPExcel to parse several Excel documents. </p>

<p>One of them, called <code>SomeSheet1</code>, is a merge of all of them and its cell values are something like:</p>

<pre><code>=IF(B11="","",VLOOKUP(B11,'SomeSheet2'!$C$10:$AE$1002,7,0)) 
</code></pre>

<p>I read that I can use <code>getFormattedValue()</code>, but it gives me an uncaught exception. I suppose it is because it cannot reference another spreadsheet. </p>

<p>Is there a way to get the value of these cells?  </p>

<p><code>Uncaught exception 'PHPExcel_Calculation_Exception' with message 'SomeSheet1 !BE11 -&gt; Formula Error: An unexpected error occured' in /Applications/XAMPP/xamppfiles/htdocs/timetable/phpexcel/Classes/PHPExcel/Cell.php:291 Stack trace: #0 /Applications/XAMPP/xamppfiles/htdocs/timetable/phpexcel/Classes/PHPExcel/Cell.php(189): PHPExcel_Cell-&gt;getCalculatedValue() #1 /Applications/XAMPP/xamppfiles/htdocs/timetable/excelparser/ClassExcelParser.php(63): PHPExcel_Cell-&gt;getFormattedValue() #2 /Applications/XAMPP/xamppfiles/htdocs/timetable/test/test.php(45): ClassExcelParser-&gt;parse() #3 {main} thrown in /Applications/XAMPP/xamppfiles/htdocs/timetable/phpexcel/Classes/PHPExcel/Cell.php on line 291</code></p>