Linked data may not update in the container application when you paste cells.
IAdviseSink::OnDataChange is not called in the following scenario:
- Excel is in manual calculation mode
- The user copies an Excel range and pastes it into the linked range
Turn calculation to automatic.
Edit and re-enter the cell to have Excel determine the data type.