[Solved] Multiple 'Update Links'

Discuss the spreadsheet application

[Solved] Multiple 'Update Links'

Postby chattel » Fri Sep 14, 2018 2:45 pm

I have been using Calc for years and it works really well for our application. We have 3 files that work together to keep our inventory up to date. They are linked and held on Dropbox. When you open one it asks to Update links and we always say yes. No problems until recently when the Update Links message appears about 5 times, which is annoying. Interestingly there are about 5 links and I have checked and confirm there are no spurious links crept in. Any idea what is going on and how to get back to the single update links message?
Last edited by chattel on Sat Sep 15, 2018 12:50 pm, edited 1 time in total.
OpenOffice 4.1.5 Windows 10
chattel
 
Posts: 4
Joined: Fri Sep 14, 2018 2:23 pm

Re: Multiple 'Update Links'

Postby RusselB » Fri Sep 14, 2018 3:06 pm

Welcome to the Forums.
This has been reported before, and a relevant topic is located at https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=94237
OpenOffice 4.1.4 and LibreOffice 5.2.7.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4653
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Multiple 'Update Links'

Postby chattel » Fri Sep 14, 2018 3:17 pm

Thanks for the reference, but that thread seemed to be solved by finding the spurious links. In my case there are none. Also to establish if I have a 'circular link' problem where A to B and then B back to A, I have kept the other files closed and just opened one and the same thing with update links so I do't believe that is the case.
OpenOffice 4.1.5 Windows 10
chattel
 
Posts: 4
Joined: Fri Sep 14, 2018 2:23 pm

Re: Multiple 'Update Links'

Postby MrProgrammer » Fri Sep 14, 2018 5:13 pm

Hi, and welcome to the forum.

chattel wrote:When you open one it asks to Update links and we always say yes.
You could use Edit → Links in each spreadsheet and see if you can determine what is causing the behavior you report. But it will be simpler to use option Always and avoid the message altogether.
Screen Shot 2018-09-14 at 10.03.42 .png

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.5 Build 9789 on Mac OS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3500
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Multiple 'Update Links'

Postby chattel » Fri Sep 14, 2018 8:26 pm

Thanks Mr. Programmer. That's sounds very promising! But unfortunately it doesn't seem to help... I made the change but I still get the Update Links messages.
OpenOffice 4.1.5 Windows 10
chattel
 
Posts: 4
Joined: Fri Sep 14, 2018 2:23 pm

Re: Multiple 'Update Links'

Postby RusselB » Fri Sep 14, 2018 10:57 pm

Further searches of the forum shows many other similar posts, including [Issue] Message "Update all Links" 4.1.4 which contains a bug report and other topic references,
OpenOffice 4.1.4 and LibreOffice 5.2.7.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4653
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Multiple 'Update Links'

Postby chattel » Sat Sep 15, 2018 12:48 pm

Okay. If it's a bug, it makes sense. Thanks for the info
OpenOffice 4.1.5 Windows 10
chattel
 
Posts: 4
Joined: Fri Sep 14, 2018 2:23 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 34 guests