Linking cells between spreadsheets

Discuss the spreadsheet application

Linking cells between spreadsheets

Postby Kris » Tue May 12, 2009 10:03 pm

Q1:
I have 2 spreadsheets linked together using DDE linking. O.o.o. Vers. 3.0.1.
If a copy these files onto another computer with a different folder hierarchy, will they still work (communicate)?

Q2:
If I use the formula: =LEFT(CELL("filename");SEARCH("/[^/]+'#";CELL("filename")))
to get the file (cell) addresses for linking in a revised spreadsheet previously linked using DDE, the command fails: #NAME.

Why?
Please list any reason, why the above formula should not work?

Kris.
OOo 3.0.X on Ms Windows XP
Kris
 
Posts: 1
Joined: Tue May 12, 2009 9:43 pm

Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests