I have one spreadsheet already saved with some data, then in a new spreadsheet in the same folder on the same hard drive I'm trying to reference a cell in the previously saved spreadsheet file.
From what I've read (such as http://www.taming-openoffice-org.com/newsite/?page_id=633), I'm supposed to click
Insert on the top menu, then
Link to External Data, then choose the file and cell(s) in the External Data popup dialog. But after I choose the file, the OK button remains disabled, and the "Available Tables/ranges" box remains blank. This happens both in the Linux and Windows XP versions. What am I doing wrong?
If I select the "Update every" checkbox there is no difference; I still can't do anything because the OK button remains disabled.