ACAD 2025 Linking Excel Data to .dwg File

ACAD 2025 Linking Excel Data to .dwg File

BillAllenSE
Collaborator Collaborator
1,370 Views
6 Replies
Message 1 of 7

ACAD 2025 Linking Excel Data to .dwg File

BillAllenSE
Collaborator
Collaborator

I've tried two methods in linking Excel data to an AutoCAD drawing:
1. Copy the Excel data then use Paste Special/Paste Link

2. Use Annotate/Link Data

While the method 2 gives me much more control on what the table looks like, it's incredibly slow updating the table when the data changes. Using method 1, the update is instantaneous.

Could there be something wrong in the way I use Annotate/Link Data?
Thank you

0 Likes
1,371 Views
6 Replies
Replies (6)
Message 2 of 7

TheCADnoob
Mentor
Mentor

How slow is slow?

 

Is the linked file on the local machine or on a network?

CADnoob

EESignature

0 Likes
Message 3 of 7

BillAllenSE
Collaborator
Collaborator

Local. In the same directory.

 

38 Mississippis.

0 Likes
Message 4 of 7

VincentSheehan
Advisor
Advisor

I attached a 213k Excel file into a blank 2025 DWG file. Made a few number adjustments to the Excel file then updated the data link. It took about 30 seconds to update. I did the same in 2023 and it took about 33 seconds. I also played with the settings but it did not speed up the sync.

 

Table.png

Vincent Sheehan

Sr. Civil Designer
Poly In 3D Blog

Message 5 of 7

BillAllenSE
Collaborator
Collaborator

Thanks for doing that.

Even when I go to edit the link (Annotate/Tables/Link Data and right mouse click on the link), it takes about the same time. There should be no issue with my machine. If in fact this is "normal" for this operation, I believe it should be looked at by the developers. 30 seconds in this day and age for a single change of data in a table is not practical.

 

0 Likes
Message 6 of 7

pendean
Community Legend
Community Legend

@BillAllenSE wrote:

I've tried two methods in linking Excel data to an AutoCAD drawing:
1. Copy the Excel data then use Paste Special/Paste Link

2. Use Annotate/Link Data

...


Nothing new, see historical posts on the matter

https://www.google.com/search?q=autocad+connected+to+excel+is+slow  

 

Unverified solutions posted by those wanting to solve it: purchase and use a 3rd party add-on.

0 Likes
Message 7 of 7

BillAllenSE
Collaborator
Collaborator

OLE paste link works pretty fast. The only downside is that you can't do much with the table graphics, but, for me, that's of little consequence.

0 Likes