poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Beardsley <markbrd...@tiscali.co.uk>
Subject Re: External cell references
Date Wed, 20 Feb 2013 09:35:21 GMT
No idea if this will work as I cannot test it out myself at the moment, but I
just found this googling for the exact syntax for external links;

*/"What an external reference to another workbook looks like

Formulas with external references to other workbooks are displayed in two
ways, depending on whether the source workbook — the one workbook that
supplies data to a formula — is open or closed.

When the source is open, the external reference includes the workbook name
in square brackets ([ ]), followed by the worksheet name, an exclamation
point (!), and the cells that the formula depends on. For example, the
following formula adds the cells C10:C25 from the workbook named Budget.xls.

External reference


When the source is not open, the external reference includes the entire

External reference


 Note    If the name of the other worksheet or workbook contains
nonalphabetical characters, you must enclose the name (or the path) within
single quotation marks."/*

Do not know if you have tried this as you have not posted any code but it
might be worth a punt.


Mark B

PS: The page I got that from is

View this message in context: http://apache-poi.1045710.n5.nabble.com/External-cell-references-tp5712128p5712139.html
Sent from the POI - User mailing list archive at Nabble.com.

To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message