OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Reference a cell with formula in other workbook

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
lgp
Newbie
Newbie


Joined: 27 Oct 2011
Posts: 4

PostPosted: Thu Oct 27, 2011 1:13 am    Post subject: Reference a cell with formula in other workbook Reply with quote

Ok this should be an easy one...but for the life of me i can't get it to work.

All i need to do is take a cell that has a =sum in it and display it in a seperate ods file.

So what i've been doing is going to the second file, entering = and then swaping files and clicking the formula cell i want to be referenced.


='file:///C:/test/test 1.ods'#$Sheet1.C2

that's what it looks like. So anyway...the total that shows up in the cell should be 16...but it just shows a 0. i don't know what im doing wrong.

help please!
Back to top
View user's profile Send private message
lgp
Newbie
Newbie


Joined: 27 Oct 2011
Posts: 4

PostPosted: Thu Oct 27, 2011 1:28 am    Post subject: Reply with quote

so it seems the problem is more that it's not updating numbers when i change values. In the two cells i have 8 and 8. so the cell im trying to reference is =sum blah blah...it = 16

so when i reference that cell 16 shows up. now when i change the values it just stays at 16. also when i delete the reference and add it again. it's still 16 even though the other cell is saying 12 or something else.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu Oct 27, 2011 1:41 am    Post subject: Reply with quote

[Tutorial] External Links In Calc
Even though we have no less than 5 different ways to link spreadsheet files to each other, this should be avoided at any cost. Simply put it all in one spreadsheet file or use a real database (no, a spreadsheet collection is no database at all).

file:// links are supposed to work even when the source file is not availlable so the target document works with an internal data copy. A manual refresh tries to update that internal copy from the source file.

DDE links refer to the fully loaded source document(s) and propagate updates.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
lgp
Newbie
Newbie


Joined: 27 Oct 2011
Posts: 4

PostPosted: Thu Oct 27, 2011 1:49 am    Post subject: Reply with quote

There too much data to be in one file. it would be too complicated. Which is why im assuming linking was even created.

ive seen this work in excel with no problem at all. How do you do a manual refresh
Back to top
View user's profile Send private message
gerard24
OOo Enthusiast
OOo Enthusiast


Joined: 08 Jul 2011
Posts: 100
Location: France

PostPosted: Thu Oct 27, 2011 2:34 am    Post subject: Reply with quote

Edit > Links
In Excel, majority of formulae won't work if source file is closed.
_________________
LibreOffice 3.5.0 on Windows Vista
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu Oct 27, 2011 2:56 am    Post subject: Reply with quote

Calc supports more than a million rows, 1024 columns and 256 sheets so there can not be too much data. Excel and Calc are store them in the same file anyway, even when you link them.

If people would only stop wasting their time with spreadsheets and spend a fraction of time and effort with databases. A most simple flat dBase table can have Gigabytes of data without memory issues.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
lgp
Newbie
Newbie


Joined: 27 Oct 2011
Posts: 4

PostPosted: Thu Oct 27, 2011 3:39 am    Post subject: Reply with quote

Villeroy wrote:
Calc supports more than a million rows, 1024 columns and 256 sheets so there can not be too much data. Excel and Calc are store them in the same file anyway, even when you link them.

If people would only stop wasting their time with spreadsheets and spend a fraction of time and effort with databases. A most simple flat dBase table can have Gigabytes of data without memory issues.


no one wants to sort through a spreadsheet that has 256 sheets.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu Oct 27, 2011 4:13 am    Post subject: Reply with quote

lgp wrote:

no one wants to sort through a spreadsheet that has 256 sheets.

Why not? It updates references which was your original request. For the rest you may use the navigator or a navigation sheet.
All I suggest is one single sheet for all equally structured data. A flat dBase table without row limits would be much better then.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group