Re: Linking External Workbooks

On Wed, 5 Oct 2016, Blake Watson wrote: I've also tried putting in "[1]" or "1" in the map rather than my spreadsheet name. I don't see in all this how the spreadsheet name in Excel comes out as "[1]" in POI. That's just how Excel stores it for XLSX files. The link table provides the mapping

Re: Linking External Workbooks

Thanks again, Nick! On Thu, Oct 6, 2016 at 11:12 AM, Nick Burch wrote: > On Thu, 6 Oct 2016, Blake Watson wrote: > >> That's just how Excel stores it for XLSX files. The link table provides >>> the mapping between those indexes and the names shown in Excel. When POI >>>

Re: Linking External Workbooks

​Thanks for the assist, Nick! ​ > ​>​ > That's just how Excel stores it for XLSX files. The link table provides > the mapping between those indexes and the names shown in Excel. When POI > hits one of those, it goes to the link table to find the name of the file, > then checks for a setup

Re: Linking External Workbooks

On Thu, 6 Oct 2016, Blake Watson wrote: That's just how Excel stores it for XLSX files. The link table provides the mapping between those indexes and the names shown in Excel. When POI hits one of those, it goes to the link table to find the name of the file, then checks for a setup referenced

Re: Linking External Workbooks

So, I've got this working now, thanks again. When I did my simple test, I noticed that a formula evaluator (which is documented as keeping "a cache of all previously calculated intermediate cell values") actually keeps ALL values around, whether they were calculated or just entered. So, if I did