| View previous topic :: View next topic |
| Author |
Message |
JWilliamCupp
General User
Joined: 26 Aug 2004
Posts: 7
Location: Marion, Indiana
|
 Posted: Fri Apr 14, 2006 9:37 am Post subject: External Links in OOo Calc |
 |
|
I have a (large) Calc spreadsheet which includes several links to external files. I don't want them there but I have difficulty finding them all to remove them.
Is there a clever way to locate all external links in a Calc spreadsheet file? |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Fri Apr 14, 2006 10:05 am Post subject: |
|
|
That depends on the kind of links.
See my answer at http://www.oooforum.org/forum/viewtopic.phtml?t=34212
Menu:Edit>Links
In case of URL-links you may want to remove the hidden sheets as well. (Menu:Format>Sheet>Show) The dialog allows multiple selection.
You can select multiple sheets as well in order to remove them in one step.
The third kind of link could be a link to a database, which can be removed by removing the corresponding database-range. |
|
| Back to top |
|
|
JWilliamCupp
General User
Joined: 26 Aug 2004
Posts: 7
Location: Marion, Indiana
|
| Posted: Fri Apr 14, 2006 10:45 am Post subject: Got it! |
|
|
| Thanks. |
|
| Back to top |
|
|
|
