External cell references

[Pavel Kotucek <pa...@gmail.com>]

Hello,

I would like to ask you - is there possibility to create new cell with
formula referencing cells from external workbook? When I create cell with
formula containing external references it is evaluated wrong (link to
external file is cut) and so final file contains cell with wrong formulas.

What to do to create formula with external reference? I tried to find
answer over internet but I can't find any hit.

Thanks

Pavel

Re: External cell references

[Mark Beardsley <ma...@tiscali.co.uk>]

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