On Thursday 31 January 2008 08:50:19 Daniel Haude wrote: > Hello, > I've created links to an external OO spreadsheet by typing '=' in a cell, > then clicking on a cell in another open sheet. Worked fine. > > But then I wanted to get rid of those references. So I marked the range of > references cells, hit Ctrl-C and then did Edit->Paste Special and selected > "Numbers". Sure enough, this just gave me the numbers and removed the > links. However, whenever I open that document, OO asks me if I want to > update the external links. I've gone over every last damn cell of my sheet > and couldn't find any external references, anywhere. > > Is there a way to get rid of this? > > Thanks,
Open the spreadsheet in OOo. Click No to the question, Do you want to update. Edit > Links to open the Edit Links window. There is likely to be several links listed. Highlight all of them, and then click the Break links button at the bottom right of the Edit Links window. Click Close and save the file. This should do it. Dan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
