On Thursday February 08 2007 8:24 pm, Johnny Andersson wrote:
> Hi!
>
> I ran into a minor problem yesterday. I have created a spreadsheet
> with a few sheets. On one of those sheets I used one column for a
> list of words. In another spreadsheet (another file actually) I
> have another list of words and I wanted to make sure that no words
> of the first list exist in the list in the other file, so I just
> used another column with VLOOKUP formulas in it, which look for a
> word in the other file.
>
> This worked nice and when I found all the words that actually
> existed in the other file I could just remove them.
> When this was done I also removed the column with all the VLOOKUPs.
>
> Both files was then closed and when I opened the first one I got a
> message telling me that there are links to another file and it was
> therefor asking me if I want to update all links or not, but there
> ARE NO LINKS there anymore! I have tried most things, even
> selecting quite a few columns and removing them, and I can't find
> any formulas with references to another file, STILL this message
> show up every time I open the file.
>
> I use OpenOffice.org 2.1 and the OS is Windows XP at the moment.
>
> Regards
>
> Johnny Andersson
Open the offending spreadsheet. When asked about updating the
links, click No. Look at Edit > Links. Are there any links listed in
it?
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
