| View previous topic :: View next topic |
| Author |
Message |
trevorh7000
General User
Joined: 02 Jun 2007
Posts: 7
|
 Posted: Mon Dec 19, 2011 5:15 am Post subject: Linked file keeps coming back even if I break link |
 |
|
Following on my previous question about finding out which files are linked to which was answered in record time - thanks Ken!
So I discovered why this spreadhseet was asking me to update the lnked file each time I opened it by going to Edit | Links
The culprit is a non existant file in /home/wildfig/Documents/pmt-sep.A
The file simply is not there and I never intentionally linked to another file. There is an option to break the link which I do and then I save the spreadsheet but on opening it again it prompts to upate the linked files and on checking Edit | Links the phantom linked file is there again.
Open Office 3.2.0 on Ubuntu 10.04.3. The spreadsheet as 57 tabs and the main tab has 25000 rows and it is password protected. I have some tabs that have pmt-sep in them.
I could try an copy out all the information into a new spreadsheet - but if I can fix the problem all the better.
Thanks
Trev |
|
| Back to top |
|
 |
mgroenescheij
Super User
Joined: 20 Apr 2011
Posts: 862
Location: Australia
|
| Posted: Mon Dec 19, 2011 1:46 pm Post subject: |
|
|
Hi,
It should be nice if you provide a link to your previous question so we know what your talking about.
Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
trevorh7000
General User
Joined: 02 Jun 2007
Posts: 7
|
| Posted: Thu Dec 22, 2011 10:54 am Post subject: |
|
|
I did not provide a link to the original question as it did not have any relevance to this question - but to summarize I asked how to see which files were being linked to and the answer was to use Edit | Links - this showed me the file that was being linked to in my spreadhseet that is a phantom file and does not exist.
The link that even when broken comes back to haunt me
Thanks
Trev |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu Dec 22, 2011 12:44 pm Post subject: |
|
|
As long as any cell formula, conditional format, range name or validation condition refers to 'file:///path/name.ods'#$Sheet.X99 the link will be created on every recalculation. Use the find/replace tool to find all formulas referring to that file and do whatever you find appropriate with these references.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
