[Solved] Linking cells form other calc files

Discuss the spreadsheet application
Post Reply
bit3m3
Posts: 9
Joined: Tue Dec 11, 2007 5:22 pm

[Solved] Linking cells form other calc files

Post by bit3m3 »

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
Last edited by Hagar Delest on Tue Jun 10, 2008 3:52 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
thomasjk
Volunteer
Posts: 4451
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Linking cells form other calc files

Post by thomasjk »

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
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Linking cells form other calc files

Post by Villeroy »

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
Bob
Posts: 8
Joined: Thu Jan 03, 2008 8:38 pm

Re: Linking cells form other calc files

Post by Bob »

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.
Ditto.
thomasjk
Volunteer
Posts: 4451
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Linking cells form other calc files

Post by thomasjk »

Villeroy wrote:This can not work with a new (unsaved) document.
The original poster said sheet not file. I interpreted that to mean the same file. I agree with your statement if its another file.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
bit3m3
Posts: 9
Joined: Tue Dec 11, 2007 5:22 pm

Re: Linking cells form other calc files

Post by bit3m3 »

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
Post Reply