Sign in to join the conversation:
I accidently added linkage from one sheet to another. How do I remove those linkages? There are a total of 10 rows and 12 columns that were linked.
Thanks!
You can select all the linked cells then right-click and choose - Remove Link. Then you will need to delete the linked cell data
Thank you very much! I found out I could only remove the link from the source page. You saved me so much time!
Glad I could be of assistance!
Thanks @Mike Wilday . I am having the same trouble; however, I don't have the option to remove link.
This is what I am seeing after I right-click.
@Dolley It looks like you are selecting content that is not linked from other sheets. Try selecting the content one column at a time.
@Mike Wilday I have been deleting cells one by one and I'm looking for a better way to do it. Unfortunately, the sheet where I intended to link this work has been deleted because I couldn't figure out how to make it work. As a result, the source sheet still shows arrows pointing out even when I select the group in a column. However, the option to remove them is not available to me.
I would reach out to support. I'm not sure how to resolve that. But that makes a lot of sense.
As always, @Mike Wilday , thanks for your help and prompt responses.
You're welcome!!! :D
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
