User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives

Skip to content

Why "Update All Links?" when opening my file?

Discuss the spreadsheet application
Post a reply

Why "Update All Links?" when opening my file?

Postby bandslak » Fri Mar 06, 2020 10:00 pm

It seems mainly on spreadsheets but why do i keep getting the "Update All Links?" message when opening?
Last edited by MrProgrammer on Tue Mar 10, 2020 4:46 pm, edited 1 time in total.
Reason: Changed subject, was: Links
OpenOffice 4 Windows 8.1
bandslak
 
Posts: 11
Joined: Fri Feb 03, 2017 4:09 pm
Top

Re: Links

Postby Villeroy » Fri Mar 06, 2020 10:13 pm

See menu:Edit>Links...
Find any formulas containing DDE( or 'file:///
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29477
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany
Top

Re: Links

Postby bandslak » Fri Mar 06, 2020 10:40 pm

and? No formula's at all that I can see or either DDE or file:/// ????
OpenOffice 4 Windows 8.1
bandslak
 
Posts: 11
Joined: Fri Feb 03, 2017 4:09 pm
Top

Re: Links

Postby Villeroy » Fri Mar 06, 2020 11:39 pm

But you do see one or more links in menu:File>Edit...
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29477
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany
Top

Re: Links

Postby Bill » Sat Mar 07, 2020 2:00 am

bandslak wrote:and? No formula's at all that I can see or either DDE or file:/// ????

When you go to Edit > Links, what happens when you click "Links"?
AOO 4.1.9 on Ubuntu MATE 20.04
Bill
Volunteer
 
Posts: 8161
Joined: Sat Nov 24, 2007 6:48 am
Top

Re: Links

Postby bandslak » Sat Mar 07, 2020 4:30 am

An "Edit Links" box comes up with over 100 lines of "8x16_spacer.png PNG-Portable Network G Graphic Manual"
OpenOffice 4 Windows 8.1
bandslak
 
Posts: 11
Joined: Fri Feb 03, 2017 4:09 pm
Top

Re: Links

Postby RoryOF » Sat Mar 07, 2020 10:38 am

Select these and break the link.
Apache OpenOffice 4.1.9 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32357
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland
Top

Re: Links

Postby Villeroy » Sat Mar 07, 2020 11:58 am

Click the list, hit Ctrl+A to select all entries, click the "break links" button
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29477
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany
Top

Re: Links

Postby Zizi64 » Sat Mar 07, 2020 2:33 pm

An "Edit Links" box comes up with over 100 lines of "8x16_spacer.png PNG-Portable Network G Graphic Manual"


Maybe you (or other persons) have copied some formatted content into your file together with the links.
Never paste formatted contents from foreign sources. You can not control if unnecessary contents and formatting properties will be inserted into your file. Use the "Paste special - As unformatted text" option.
Tibor Kovacs, Hungary; LO6.1.6, 6.4.7 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.1.1;AOO4.1.9
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9799
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary
Top
Post a reply

Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 16 guests

Apache Software Foundation Forum powered by phpBB © phpBB Group
By any use of this Website, you agree to be bound by these
Policies and Terms of Use 		Get OpenOffice
Get OpenOffice