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

=SUM([Budget.xlsx]Annual!C10:C25)

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

External reference

=SUM('C:\Reports\[Budget.xlsx]Annual'!C10:C25)

 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.

Yours

Mark B

PS: The page I got that from is
http://www.likeoffice.com/28057/Excel-2007-Working-with-external-links



--
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


Mime
View raw message