MicroStation Forum Excel crashes when table is pasted as link in microstation

Excel crashes when table is pasted as link in microstation

Offline Rakhi Bhargava Thu, Jul 11 2019 12:43 PM

Steps taken

- 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?

Top Replies

Offline Duncan Macdonald Fri, Jul 12 2019 11:04 AM in reply to Rakhi Bhargava +1

Bentley will tell you that that is not a supported config as the version of Excel is much newer than your version of Microstation. Having said that it can be made to work. Try saving your Excel as an...

0 Offline Rakhi Bhargava Fri, Jul 12 2019 12:06 PM in reply to Duncan Macdonald

Thanks Duncan. our file has macros but I tried without macros xlsx, xls even and excel crashes everytime.
Cancel
Up 0 Down

Verify Answer

Cancel
0 Offline Duncan Macdonald Fri, Jul 12 2019 12:18 PM in reply to Rakhi Bhargava
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.
Cancel
Up 0 Down

Verify Answer

Cancel
0 Offline Jon Summers Fri, Jul 12 2019 12:24 PM in reply to Duncan Macdonald
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
Cancel
Up 0 Down

Verify Answer

Cancel
0 Offline Duncan Macdonald Fri, Jul 12 2019 12:28 PM in reply to Jon Summers
Latest Office 365 version 16 same as the OP which is why I didn't mention it.
Cancel
Up 0 Down

Verify Answer

Cancel
0 Offline Reginald Wallace Fri, Jul 12 2019 4:24 PM in reply to Duncan Macdonald

Duncan,

Is this file-specific? Can you reproduce this issue with another spreadsheet and/or DGN file?

Regards,

Regie
Cancel
Up 0 Down

Verify Answer

Cancel