Data link table

[janakaL6JKK]

Hi All,

Can anyone please help me with this? 

In the screenshot, generated tables using the same excel through data link on my computer and another computer, but my computer appears as small text and table size also mismatch. I have checked with fonts, table styles any many ways, but I can't sort out this.

[cheryl.buck]

Hi @janakaL6JKK,

That is unexpected. It kind of looks like an import setting could be affecting the scale.  Can you check the Datalink Import settings are the same on both computers, as shown in this post?

If a post answered your question or resolved the issue, please click the Accept Solution button.

Likes are always welcome.

All the best,

[tony1978]

Hi there. Just curious have you tried using the .xlsx file when you are in Excel? That's is the file format that I use when I Import drainage area maps, and hydraulic tables. I dont use the .csv file format 

Please click Accept Solutions if this worked for you. Thank you

[janakaL6JKK]

I'm using excel with the *.xlsx file for the data link. Not use *.cvs.

[janakaL6JKK]

As post you have the tag, I can't access the text height of the tables (as per attached).

 

[tony1978]

Most likely the cells are locked. Select the first cell on the upper left and hold down the shift key and select the last cell at the lower left corner. Then on the ribbon under format, there is pull down under Cell Locking, select unlocked. This will allow you to change all the cell heights at one time. 

[tony1978]

let me know if this worked, 

[janakaL6JKK]

Thank you for the reply.

I don't need to do this manually. 

I need to fix this issue to match the same table properties to other computers. 

[tony1978]

hmmm like a preset setting? I will say that when i bring in the data link it works just fine 95% of the time. The other 5% of times one or two are the wrong size so I have to manually change it back. I honestly dont know what causes for one or two cells to not work properly.  I will have to look to see when you insert the table it can be set to unlock all set as a default. 

[janakaL6JKK]

I have used this table as many drawings for few years without any problem. 

But on this new laptop (I hope) I got this error. 

[tony1978]

possible another option for you is to use the Insert Ole object and linked it to the spread sheet. 

[tony1978]

this options will give you an notification if the spreadsheet has been updated. 

[tony1978]

on your new laptop are you pointing to a company font folder under the Options/File tab? 

[janakaL6JKK]

No, how can I do that?

[janakaL6JKK]

I have re-installed it, but the same result.  

[Valentin_CAD]

@janakaL6JKK ,

To insert consistently sized tables, uncheck Use Excel Formatting for new data links.

• Tables insert at different sizes in AutoCAD depending on the Windows text scaling setting

Also consider this other link:

• Formatting of pasted Excel table is not as expected

[janakaL6JKK]

Alternatively, a cell style can be made from the original table and the new table can be matched to it: 

1. Click a cell in an existing table.
2. Right-click > Cell Style > Create new style from cell.
3. Name and save it.
4. Click in the new table.
5. Select all the cells.
6. Right-click > Cell Style and pick the style.

This works well when the smaller cells are sizing up to fit the larger text style

This method works well, but the thing is I have to do this for each and every drawing by da today and It's very difficult.