Calc charts not updating correctly [closed]

asked 2017-11-14 14:32:37 +0100

BigAl gravatar image

updated 2020-10-20 01:16:42 +0100

Alex Kemp gravatar image

LO version 5.1.6.2 running on 64 bit Linux Mint 17.3

I store a lot of monthly readings in various LO Calc pages. There are links to separate Calc charts that should shew the current numbers. Some do and some do not. The links were set up by copying the required cell in the readings pages and then using ‘Paste special’ and selecting the ‘Formula and in the options section the ‘link’ tick box. Some of the links update correctly, some do not shew at all until I press recalculate links (F9). What is more, sometimes the F9 combination results in the chart displaying all the data in a flat row across the bottom of the chart.

When I open any of the data pages I am always told “ This file contains links to other files. Should they be updated?”. I always say ‘Yes’ but it makes no difference. Can anyone make any suggestions to help please?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2021-02-07 01:03:32.865662