Additional Link cells not working

Discuss the spreadsheet application

Additional Link cells not working

Postby ralphd » Wed Mar 13, 2019 12:04 pm

Good day

I have 20 sheets linking to my first sheet,and unable to link an additional 5 sheets ive added to the spreadsheet.
To specify the problem,theres one cell in each of the additional sheets which will not link.Other cells are fine.
Its a document so I cant remove the cell,as it needs the data in that specific place.

I've tried comparing sheet 20 with 21 with one notable difference that I couldn't fix.
Sheet 20 cell number reflects =$Pensioner.G32 & sheet 21 cell is =Pensioner.G33
which I alter to =$Pensioner.G33 and still it will not link.

Please may you advise me ?

Thank you
cell.png (2.76 KiB) Viewed 382 times
OpenOffice 3.4 on windows 7
Posts: 10
Joined: Thu Jun 28, 2012 9:28 am

Re: Additional Link cells not working

Postby jrkrideau » Wed Mar 13, 2019 8:47 pm

I think that we probably need an example. Is there any way for you to cut down the size of the file while still showing the problem and uploading it here? There is an upload tab at the bottom of the Quote and Reply windows.

The forum has a maximum file size of 128k. If your example is larger you will need to upload to a file hosting site such as
Dropbox or MediaFire and post the download link here.
LibreOffice; Ubuntu 20.04
Posts: 3782
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Additional Link cells not working

Postby Lupp » Wed Mar 13, 2019 8:57 pm

ralphd wrote:...which I alter to =$Pensioner.G33 and still it will not link.

-1- Did you enter the formula manually, or did you create the reference by clicking into the respective cell?
-2- In what way did the result show you that "it will not link"?
-3- Are you sure that the cell where you put the formula in not is set to the (fake) 'Numbers' format code "@"?
Last edited by Lupp on Wed Mar 13, 2019 10:06 pm, edited 1 time in total.
On Windows 10: LibreOffice 6.4 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
Lupp from München
User avatar
Posts: 2809
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Additional Link cells not working

Postby Villeroy » Wed Mar 13, 2019 9:13 pm

You can make a copy of your file and delete everything that is not related to the problem and upload a small version of your file.

This is how references work in all spreadsheet programs: viewtopic.php?t=2443
The only thing that is special in Calc is that Calc knows relative and absolute sheet references.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Posts: 28228
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Calc

Who is online

Users browsing this forum: No registered users and 13 guests