topic Re: differing Excel sheets data linked to differing layouts in same drawing not in AutoCAD Forum

differing Excel sheets data linked to differing layouts in same drawing not work

Anonymous — Mon, 23 May 2016 16:02:21 GMT

Using Mechanical 2016 stripped down to AutoCAD Vanilla

I have an Excel spreadsheet on which I have say 2 different sheets with different names

I have one dwg drawing with say 2 layouts

I datalink one Excel sheet to one of the layouts & then change to the second layout & data link the second Excel sheet to that

I go back to layout 1 & the Excel sheet here has also changed to the second sheet

It seems I cannot have different sheets of the same Excel file linked to different layouts in the same AutoCAD file

I don't recall this happening previously - is there a new setting I missed somewhere?

john.vellek — Mon, 23 May 2016 17:37:18 GMT

HI @Anonymous,

Please attach the Excel file and the drawing so I can take a look and verify your results.

Anonymous — Tue, 24 May 2016 09:19:29 GMT

I have attached a drawing file with 2 sheets

I have attached the actual Excel spreadsheet I picked the problem up on

On sheet 1 (named 20152050-GA-001) I attached a sheet from the Excel file

On sheet 2 (named 20152050-GA-002) I attached another sheet

Change 1 sheet & the other will change too

john.vellek — Tue, 24 May 2016 15:00:07 GMT

Hi @Anonymous,

I took your file and removed the two linked tables and then removed the datalink.

I then created two datalinks: one for each Excel page and named range.

I then inserted two tables - each one linked to it's own datalink.

I can update Excel and the tables respond appropriately.

I am not sure this is how you go through the process but it has always behaved correctly for me when I follow these steps.

Please hit the Accept as Solution button if my post fully solves your issue or answers your question.

Anonymous — Wed, 25 May 2016 11:29:53 GMT

John

Aha - you have hit the nail on the head

What I did was create the first GA then copy that sheet, went to the new sheet & edited the datalink...

What I shoudl be doing is recreating a new datalink for each sheet.

Thanks 🙂