KNOWLEDGEBASE - ARTICLE #1160

Unlinking data objects linked to Excel or text files. 

When you import text files onto a Prism data table, you can choose to have Prism link the data object to the text file. You then will not be able to edit the data within Prism. But if you edit the file, Prism will update. With Prism Windows, you can also link data from Excel files. 

To unlink a data object:

Right click (control click on the Mac) on the object, choose Data Object >, and then choose Unlink. 

If the linked file no longer exists (or has moved or been renamed):

Double click on the object. Prism will tell you the file no longer exists, and that message box has an Unlink button. Click it. On Prism Mac 5.0a, the message box will stay up, so you then need to click Cancel. 

To unlink all the objects in a file: (Windows only)

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.

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

 

Explore the Knowledgebase

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