My Prism file has many data objects linked to Excel. How can I unlink them all?
- Go to a data table.
- Drop the Edit menu and choose links.
- Click on the first linked object in the list.
- Hold shift and click on the last linked object.
- Click 'Break Link".
- Confirm that you want to break the link.
- 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