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
