topic Re: Updating Excel file in autocad 2016 in AutoCAD Forum

Updating Excel file in autocad 2016

Anonymous — Tue, 03 Apr 2018 18:04:29 GMT

I use Excel 2016 and AutoCAD 2016. When I bring in a table from Excel 2016 into AutoCAD 2016 (using copy from Excel 2016 then using paste special "paste link") to bring the table into AutoCAD everything seems to work perfectly but the shaded cells do not print with the shaded color. This works fine if I use Excel 2007 but we just upgraded to Office 2016 and I don't want to keep going back to the old 2007 version so I can bring in the tables. Any ideas why this doesn't print properly? It doesn't print when I print to PDF or directly to the printer. Everything shows up except for the shaded cell color.

Re: Updating Excel file in autocad 2016

WarrenGeissler — Tue, 03 Apr 2018 18:39:27 GMT

We'll need some samples from you. Attached is a PDF of an Excel 2016 Copy / Paste into Civil 3D 2016 (one as an OLE and one as AutoCAD entities) and the shaded cells work fine.

First - Which option in Paste Special are you using

Second - type ABOUT in AutoCAD and tell us which product version (and SP level) you are using.

Re: Updating Excel file in autocad 2016

Anonymous — Tue, 03 Apr 2018 18:53:33 GMT

I am using AutoCAD Map 3D 2016: M020AP

built on: M. 49.0.0 AutoCAD 2016

The attached PDF file has 2 pages. The 1st page shows the Excel boxes as they print from AutoCAD and the 2nd page shows a screen capture of the same thing from AutoCAD. Notice that the yellow highlighted cells are in both versions on the screen but only print when the boxes are imported from Excel 2007.

I use "paste special" and the "paste link" "Microsoft Office Excel Worksheet" options to bring them into AutoCAD. This has worked for all my previous versions of AutoCAD and previous versions of Excel. This problem only started when we upgraded to Microsoft Office 2016.

Re: Updating Excel file in autocad 2016

Anonymous — Tue, 03 Apr 2018 19:12:49 GMT

Another piece of information.

When I do a print preview, everything looks fine and the color shading in the cells show up fine then when I print the shaded cells do show up as shaded. I have tried printing to PDF, and 3 other printers directly and they all are the same.

Re: Updating Excel file in autocad 2016

WarrenGeissler — Tue, 03 Apr 2018 20:01:30 GMT

Go into Excel - Click File - Click Account - Click the ABOUT EXCEL button. Are you using the 32-bit version or 64-bit version?

Along with that - I'm assuming you are on Windows 7 or 10 64-bit?

Re: Updating Excel file in autocad 2016

Anonymous — Tue, 03 Apr 2018 20:24:51 GMT

I am using Windows 10 (64 Bit)

Excel shows as 32 bit.

So are I.T. guy installed the wrong version? Can it be reinstalled as 64 bit?

Do you think that will fix the problem?

Re: Updating Excel file in autocad 2016

WarrenGeissler — Tue, 03 Apr 2018 20:42:10 GMT

@Anonymous wrote:

So our I.T. guy installed the wrong version?

Correct

@Anonymous wrote:
Can it be reinstalled as 64 bit?

Also correct

@Anonymous wrote:
Do you think that will fix the problem?

Unknown. However - that is the first thing I would look at. Most of the issues I've seen in Office products with AutoCAD belong to a mismatch of 32 vs. 64 bit loads.

Re: Updating Excel file in autocad 2016

Anonymous — Tue, 03 Apr 2018 20:56:57 GMT

Thanks. I will talk to my I.T. guy and see if that can be done easily. Where do I check my AutoCAD install to see if it is 32 bit or 64 bit?

Re: Updating Excel file in autocad 2016

WarrenGeissler — Tue, 03 Apr 2018 21:08:49 GMT

If you are on a 64-bit OS, then you have a 64-bit AutoCAD. That's the only one that can install. Autodesk (unlike Microsoft) is nice that way.

Re: Updating Excel file in autocad 2016

Anonymous — Mon, 09 Apr 2018 10:28:08 GMT

Thanks. I will get my I.T. guy to reinstall Office as 64 bit and see what happens.