KNOWLEDGEBASE - ARTICLE #1159

My Prism file has many data objects linked to Excel. How can I unlink them all?

It can be very useful to link Excel data to Prism. But if you have lots of links, Prism can slow down, especially if the linked files no longer exist. Here is an easy way to unlink them all at once.
  1. Go to a data table.
  2. Drop the Edit menu and choose links.
  3. Click on the first linked object in the list. 
  4. Hold shift and click on the last linked object. 
  5. Click 'Break Link".
  6. Confirm that you want to break the link. 
  7. Repeat for each link.

You will now have an ordinary Prism file with the data self-contained and no links to Excel.

Note that this method breaks all links, so be careful if there are some objects in the list you don't want to unlink.



Keywords: Links dialog, Edit links, link data, linked data, linked file, OLE

Explore the Knowledgebase

Analyze, graph and present your scientific work easily with GraphPad Prism. No coding required.