Morning Mark, Thanks for the suggestion, I tried it and unfortunately it doesn't work. Excel flags it as an invalid reference. Not sure where to go with this now. I could provide a list of possible directories and then search for the file name, but this seems like a lot of work.
Does anybody know how Excel does this internally? Cheers, Mark On 4 April 2012 18:03, Mark Beardsley <[email protected]> wrote: > Guessing here but have you tried placing the full path and name of the > workbook between the braces? Something like this > > "='[M:\Improvements\Spreadsheet Scanner\Spreadsheet > Scanner\test_data\C.xls]Sheet1'!$A$1* > > That might work - might by the way as I have never tried it myself. > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/Full-paths-removed-from-formulas-in-SS-spreadsheet-tp5617482p5618225.html > Sent from the POI - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- Mark Coleman uGly Duckling B.V. Burgemeester le Fevre de Montignylaan 30 3055LG Rotterdam, the Netherlands KvK nummer: 52272125 BTW nummer: NL850371570B.01 Rabobank: 14.68.33.473 E: [email protected] M: +31 (0) 646347972 W: http://uGlyDuckling.nl <http://www.uglyduckling.nl/>
