Help with Acad2010 and creating tables and linking to an excel spreadsheet

[sparkatrician]

Good Morning Guys

 

My first post on this forum so I'm looking for a little help.

I've previously used Autocad 2008 Electrical.

I've just started a new job and I have been asked to update some electrical drawings from a recent project.

My current employer use Autocad 2010 as opposed to Autocad Electrical which I have previously used.

 

The problem I have is that I have a drawing with a table linked to an Excel spreadsheet that displays an I/O table.

 

Since the drawings have changed the amount I/O has increased.

 

I have a new excel sheet with the new I/O list which is larger than the old I/O list.

 

When I "point" the Table to look at the new spreadsheet in the "Modify Excel Link" Dialogue and alter the "Link to Range" Tab to my new desired excel sheet and apply the changes the table. The new excel sheet populates the table correctly until the end of the old table used to stop then the format goes all to hell and the new part of the table is way out of scale and at 90 degrees out to the original table.

 

Can anyone help out or have any suggestions as to where I am going wrong?

 

I think I am possibly missing a step somehwere when updating the Data Table Links!?!?....Do I need to alter the table properties somewhere too?.

 

Any help or advice greatly appreciated.

 

Cheers

[tzframpton]

You are using DATALINK correct?

 

Some things to keep in mind:

1. Create a Table Style carefully. This is the main attribute to keeping the format nice and consistent.

2. Use the Expand arrow at the bottom right of the "Modify Excel Link" dialog box and play with the "Cell Contents" and "Cell Formatting" options to suit your needs.

 

These two tips are what keep my Data Links in tact.

[sparkatrician]

Thanks for the help.

 

I finally managed to get it sorted out this morning. I created a new data link to the new spreadsheet and altered the table properties.

 

Thanks again