- Copy table from excel
- In MicroStation pulldown Edit>Paste Special.
- From the list of Data Type selected “Linked Microsoft Excel Worksheet”
- In the Paste OLE Tool Settings dialog set the Method to By Size
After these steps we close Excel and it crashes.
Anyone experienced and know the resolutions please?
Thanks Duncan. our file has macros but I tried without macros xlsx, xls even and excel crashes everytime.
Then I'm not sure. I do use the cut and paste from Excel to the same version and it works for me so it should be possible.
Duncan Macdonald said:I do use the cut and paste from Excel to the same version [of MicroStation]
But what version of Excel do you use?
Regards, Jon Summers LA Solutions
Latest Office 365 version 16 same as the OP which is why I didn't mention it.
Is this file-specific? Can you reproduce this issue with another spreadsheet and/or DGN file?