excel OLE updated automatically

excel OLE updated automatically

johan.degreef
Advisor Advisor
1,578 Views
2 Replies
Message 1 of 3

excel OLE updated automatically

johan.degreef
Advisor
Advisor

Is there a way to display an excel worksheet in an Autocad drawing (I know OLE insert) and have it update as the excel file is modified? Now i have to delete the OLE excel in Autocad and re-insert it to have the latest data.

 

many thanks, Johan

Inventor 2025, Vault Professional 2025, Autocad Plant 3D 2025
0 Likes
1,579 Views
2 Replies
Replies (2)
Message 2 of 3

imadHabash
Mentor
Mentor

Hi,

You can bring an Excel spreadsheet into AutoCAD® as an AutoCAD table object. Follow these steps:

  1. In Microsoft Excel, select the spreadsheet area that you want to import, and copy it to the clipboard.
  2. In AutoCAD, on the Edit menu, click Paste Special. 
  3. In the Paste Special dialog box, select the AutoCAD Entities option. This will create an AutoCAD table that can be formatted to match the linetype and text style.

also you can follow this link >> Click <<  for more informatio . you can get your updates by DATALINKUPDATE (Command) . also you can Controls the notification for updated or missing data links by DATALINKNOTIFY (System Variable) .

 

Imad Habash

EESignature

0 Likes
Message 3 of 3

RobDraw
Mentor
Mentor

I would use AutoCAD tables but it's not a "live" connection. They can be updated but not automatically.


Rob

Drafting is a breeze and Revit doesn't always work the way you think it should.
0 Likes