Opening file having reference to another file

Topics: Developer Forum
Apr 3, 2014 at 10:30 PM
I need to update the content on a spreadsheet with has references and lookup to another source data excel file. Is this feature supported in PHPExcel?
Apr 4, 2014 at 5:02 PM
Plain and simple answer, "No".... it may work, it may not, all depending on what you're doing with those references and lookups; but the PHPExcel calculation engine will not go loading up external files that may or may not exist, so it tests for the last calculated result for those formulae