Preventing an inserted OLE object (Spreadsheet) from updating

Parent Category: FAQs
Category: General
Created on Wednesday, 15 December 2010 14:47
Hits: 8739

APPLIES TO

Caddie 20 onwards

QUESTION

How do I stop a spreadsheet that has been inserted into a drawing from updating when the spreadsheet is updated externally?

ANSWER

If you have inserted a 'linked' OLE object into your drawing and you update the object it came from, the version in the drawing will be updated. To prevent this, you must 'break' the link. To do this, select the object then right click and from the CSM choose 'Edit OLE links'. Choose the correct link from the dialogue and click 'break link'

Note that this action cannot be reversed. If you want to re-link an OLE object erase it from the drawing and re-insert it.

OTHER FAQ's

None.