Hi,
this works fine within different sheets of the same *file*, while is
seems to be a problem when referencing a named cell in a different file.
Uwe
Mac McClain wrote:
Uh Oh. Then you must have some kind of connection between sheets 1 & 2
that I don't have so they share variables/names. Do you know what it is?
----- Original Message ----- From: <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, July 28, 2006 7:03 AM
Subject: [users] RE [users] Calc Formula
Mac,
In my little test I defined the name old on sheet1 en put the formula
=old on sheet2. No problems there, so it works just fine in my case.
Mac McClain schreef:
Arnold -- the =old only appears to work in the same sheet.
Arnold
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
[EMAIL PROTECTED] - Technical Writer
StarOffice - Sun Microsystems, Inc. - Hamburg, Germany
http://www.sun.com/staroffice
http://documentation.openoffice.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
