Managing Fonts Used in Tables Linked to a Spreadsheet (AutoCAD 2008)
Comments(5) I love that you can link an Excel spreadsheet to an AutoCAD table. This is a very powerful tool, but I quickly discovered a problem: you can’t use .shx fonts an Excel spreadsheet.
Our CAD standards dictate that we use a .shx font but since it cannot be used inside Excel the AutoCAD table takes on the same non-standard font used in the spreadsheet. All of my AutoCAD tables linked to a spreadsheet were coming in with a non-standard font and it was a pain reformatting each and every cell. That’s when I discovered this little secret.
I could expand this dialog box and uncheck “Use Excel formatting”:
Problem solved. With this checkbox unchecked, the fonts take on the current text style in my drawing. Granted, I still need to do some formatting on the AutoCAD table, but this is much easier than reformatting each and every cell, one-by-one.
Remember, when reformatting an AutoCAD Table linked to an Excel spreadsheet, you need to unlock the cells.
Managing Fonts Used in Tables Linked to a Spreadsheet (AutoCAD 2008)…
You’ve been kicked (a good thing) – Trackback from CadKicks.com…
Or, maybe even change the standard to a real font? :)
Thank you for this great tip. I was fighting this battle and couldn’t find any answers. Thanks a lot!
Dude. Thanks so much for this. I can’t tell you how much I’ve racked my brain trying to figure out why the plotting service keeps messing up my tables. It prints fine here, but when you send the DWF out, it comes back as Arial all over. This way works by putting all text into ACAD terms. I’ve wasted alot of time on this thinking it was resolution issue or embedding fonts issue. All along it was the “keep Excel formatting” box that was causing the ‘replacement font’ to kick in. I searched all over the internet, but no solution came up until this.
You are the best… I love you.
(OK that may have gone too far.) But really… Thanks.