Reference a cell with formula in other workbook

lgp · Newbie Joined: 27 Oct 2011 Posts: 4

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!

lgp · Newbie Joined: 27 Oct 2011 Posts: 4

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.

Villeroy · Posted: Thu Oct 27, 2011 1:41 am Post subject:

[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 http://forum.openoffice.org

lgp · Newbie Joined: 27 Oct 2011 Posts: 4

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

gerard24 · Posted: Thu Oct 27, 2011 2:34 am Post subject:

Edit > Links
In Excel, majority of formulae won't work if source file is closed.
_________________
LibreOffice 3.5.0 on Windows Vista

Villeroy · Posted: Thu Oct 27, 2011 2:56 am Post subject:

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 http://forum.openoffice.org

lgp · Newbie Joined: 27 Oct 2011 Posts: 4

Villeroy · Posted: Thu Oct 27, 2011 4:13 am Post subject: