Editing tables connected to Excel by Data Link

[RalphBrown99]

Hi:

I have right now a table that is connected to Excel by Data Link and the data downloading to AutoCAD is working fine. However at some point the table show up with an extra column that I do not need and I cannot delete. Every time that I select either one of the cells that belong to the column or the column itself, the Delete Columns Options is Grey out at the top of the menu.

To help to understand the problem I am sending out a .png file

Regards

Ralph

[pendean]

>>>...a table that is connected to Excel...<<<
Can you not do it in the Excel document, in Excel? That's how we would fix that here in the source file/program.

[RalphBrown99]

Hi, thanks for your re-paly. The extra-column that I have in the AutoCAD table does not even exist in the original Excel File.

Regards

R

[pendean]

Are you sure you opened the correct Excel document?

Any chance you can hare both file here instead of a screenshot?

[RalphBrown99]

Hi, I just found out that there is a hide Column in the Excel source file

Fixing there in Excel not in AutoCAD is your suggestion?

Regards

R

[pendean]

Update the link after you make the change in Excel and after you save the file in Excel, like this https://knowledge.autodesk.com/support/autocad/learn-explore/caas/CloudHelp/cloudhelp/2016/ENU/AutoC...

[RalphBrown99]

Hi, thanks for your help. I solved by merging cells by row

Regards

R