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

Discuss the spreadsheet application

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

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: 29691
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

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: 29691
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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.10 on Ubuntu MATE 21.04
Bill
Volunteer
 
Posts: 8240
Joined: Sat Nov 24, 2007 6:48 am

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

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: 32523
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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: 29691
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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: 9837
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: No registered users and 10 guests