Excel to Microstation

I'm having trouble linking Excel to Microstation. I select what I need to copy to Microstation and then I paste special as "Linked text to Design File". When it comes in, the columns and rows are not lined up. I'm also doing this in ProjectWise so the only time the spreadsheet is linked is when I have the drawing open. When I close out and come back in, it is no longer linked. 

Does anybody have any suggestions without using AXIOM? I've attached some pictures to show what I'm talking about.

  • Hello,
    Can you specify the version of MicroStation you are using? It can be found in:
    HELP>ABOUT MICROSTATION
    The version will be in the form of: 08.XX.XXX.XXX

    Could you also specify which version of Excel the file was created in?
    Are there any messages listed in the Message Centre when this issue occurs?
    Does the same issue occur when MicroStation alone is used?

    Regards
    Derval Canny.



  • I'm using Excel version 15.0.4815.1001
    I'm using Microstation version 08.11.07.443

    There are no messages listed in the message center. The issue occurs when I copy and "paste special" it in.
  • Have you tried the linked Microsoft excel worksheet option ?


  • I haven't tried that Melissa. What is that and how do you use it?
  • To Link or Embed Another Application's Document by Pasting the Document by Its Size

    1. In the source application, select the part of the document to link and then copy it.
    2. In MicroStation, choose Edit > Paste Special.
      The Paste Special dialog opens.

    3. In the Data Type list box, select one of the following:
      — Linked <object type>
      — Embedded <object type>
      In this example, “Linked Microsoft Office Excel Worksheet” appears. This item changes dynamically depending on the source application from which you are pasting.
    4. Click Paste.
      The Paste OLE Object dialog opens with the selected data type in the Object field and either Linked or Embeddedin the Paste As field.

    5. From the Method option menu, choose By Size.
    6. (Optional) If you want the pasted object to appear as an icon in the DGN file, turn on Display as icon.
    7. (Optional) If you want the pasted object to have a transparent background, turn on Transparent Background.
    8. (Optional) If you want the pasted object to rotate when the view rotates, turn on Rotate With View.
    9. In the Scale field, key in the scale of the object to be pasted.
    10. Click a data point to define the location of the object to be pasted.

    To Link or Embed Another Application's Document by Pasting the Document by Two Corner Points

    1. Follow steps 1–4 in the preceding procedure.
    2. From the Method option menu, choose By Corners.
    3. To define one corner, enter a data point.
    4. To define the diagonal corner, enter another data point.
    5. (Optional) If you want the pasted object to appear as an icon in the DGN file, turn on Display as icon.
    6. (Optional) If you want the pasted object to have a transparent background, turn on Transparent Background.
    7. (Optional) If you want the pasted object to rotate when the view rotates, turn on Rotate With View.

    MicroStation only supports TrueType fonts. If the TrueType fonts you are using in your source applications are not currently used in MicroStation, you may want to install them. Otherwise, MicroStation substitutes the Active Font (Element > Text). Because the source application defines the text by the font it is using, substituting another font may give undesirable results.