Saturday, 27 November 2010

cell reference to another file, ms excel and openoffice

Link value from another excel/spreadsheet file, using filename in a cell

excel
='c:\abc\[Test File.xls]Test Data'!$A$7

ooo calc (can also use ms excel formula )
='file:///C:/a/b/c d/e.xls'#$Data.$C$9

No comments:

Labels

Search This Blog