AutoCAD 2011. When I go to:
-Tools
- Data Links
- Data Link Manager
Under --Excel Links—I have already created 40 different excel links with different content on them and from the same excel file. So each one of the 40 excel link takes a different group of cells of the same excel file. When I want to change the excel file that the 40 excel links are linked to, I have to go to:
-Tools
- Data Links
- Data Link Manager
-Double click on ONE excel link
-under Choose and Excel File, change the excel file to the New created excel file.
-press ok. And proceed to do the same steps with all 39 left excel links.
What I want to do is change the excel file in all the data links at the same time AND TO THE SAME NEW CREATED EXCEL FILE, it's almost like just opening the excel file from a CAD excel data link, doing a SAVE AS, changing the name and, as a miracle, having all Cad excel links adapt to the new name. (When I do a SAVE AS all 40 data links are still linked to the original, not to the new saved excel file).
AutoCAD 2011 Excel Data Links
