Hi,
I'm looking for a very easy (at least I think) answer to my problem.
We used to work with excel 97
There when we wanted to link the data from a cell in an other sheet we simply pressed "=" (starting a formula)
and clicked on the other excel file / sheet / cell follwed by enter and the data from that cell was linked.
however this is not the case with OO's calc....
how do we do this?
We are using win 2003 server (terminal users)
and Open Office 2.3
Thnx
Jerry
[Solved] Linking cells form other calc files
[Solved] Linking cells form other calc files
Last edited by Hagar Delest on Tue Jun 10, 2008 3:52 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
Reason: tagged the thread as Solved.
Re: Linking cells form other calc files
It works for me if I click on the sheet tab, click on the cell and click on the Green Check mark in the formula bar. It also works if I press the Enter key.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
Re: Linking cells form other calc files
This can not work with a new (unsaved) document.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Linking cells form other calc files
Ditto.thomasjk wrote:It works for me if I click on the sheet tab, click on the cell and click on the Green Check mark in the formula bar. It also works if I press the Enter key.
Re: Linking cells form other calc files
The original poster said sheet not file. I interpreted that to mean the same file. I agree with your statement if its another file.Villeroy wrote:This can not work with a new (unsaved) document.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
Re: Linking cells form other calc files
Sorry if my question was unclear.
I have 2 separate files.
I want data from 1 file in the other.
......yesterday it did not work...I only saw the "=" and not the file location
today with a new and freshly booted windows it seems to work again pfffffff
(thnx Bill)
and you thank you for taking the time to help me.
Jerry
I have 2 separate files.
I want data from 1 file in the other.
......yesterday it did not work...I only saw the "=" and not the file location
today with a new and freshly booted windows it seems to work again pfffffff
(thnx Bill)
and you thank you for taking the time to help me.
Jerry