Cells linked and I can't see or break the link

Discuss the spreadsheet application

Cells linked and I can't see or break the link

Postby rdhartm » Thu May 02, 2019 5:33 pm

I'm baffled. I have some cells in sheet A of a Calc spreadsheet that are linked to sheet B. I didn't try to do that. It happened somehow in a copy/paste operation. I know which cells are involved in the two sheets. I can't see a link, and by that I mean cell x:y in sheet B would show =cell u:v in sheet A. All I have is a number. I've used copy/paste special number in both sheet A and sheet B, but if I delete the contents in the offending cell in sheet A, it's also deleted in sheet B. Would appreciate any help. If I could just even see all the " = [other cell referenced] " I could probably figure it out.
RH
Open Office 4.1.6, Windows 10 Home
rdhartm
 
Posts: 2
Joined: Thu May 02, 2019 5:26 pm

Re: Cells linked and I can't see or break the link

Postby RusselB » Thu May 02, 2019 8:00 pm

Welcome to the Forums.
It sounds to me that you don't have a link, but rather have multiple pages (aka tabs) selected.
Look carefully at the page(s)/tab(s) at the bottom of your spreadsheet. If only the page/tab you are on is highlighted differently (the difference might be very slight), then this is not the problem.
However, if you have 2 or more pages/tabs that look the same as the page/tab that you are on, then you have multiple pages/tabs selected.
This can happen intentionally, by pressing the Alt key while selecting a different page/tab with the mouse or accidentally by having done a command that required the Alt key, but then the Alt key didn't release.
The Shift key is also a possible culprit.

I have had both options happen to me when it wasn't intended, and it was a pain to figure out which key was the offender, especially since there are 2 shift keys and 2 alt keys.
If this is the problem, you're going to have to just play around with the Alt and Shift keys until you get something that works....Sorry that there isn't an easier solution.
OpenOffice 4.1.7 and LibreOffice 6.3.3.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.
User avatar
RusselB
Moderator
 
Posts: 5682
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

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