• +27 12 644 0300
  • +44 1234 834920
  • This email address is being protected from spambots. You need JavaScript enabled to view it.

Preventing an inserted OLE object (Spreadsheet) from updating


Caddie 20 onwards


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


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.



© 2024 Caddie Limited. All Rights Reserved.