topic Re: AutoCAD 2016 Data Extract not working with Excel 2016 in AutoCAD Forum

AutoCAD 2016 Data Extract not working with Excel 2016

mosness — Thu, 12 Oct 2017 16:35:58 GMT

When my data is output to an external .xls excel file it only has the word "Deleteme" in the A1 cell. I have not changed anything and it just worked a couple days ago. Anyone have any ideas?

Re: AutoCAD 2016 Data Extract not working with Excel 2016

kevin — Thu, 12 Oct 2017 17:07:34 GMT

I'm having the same issue....

https://forums.autodesk.com/t5/autocad-forum/deleteme-error-in-autocad-with-excel/td-p/7452909

It appears to be related to a Microsoft update released in September from what I've been able to track it down too...

Maybe @john.vellek can chime in and get more push going on this issue.

Re: AutoCAD 2016 Data Extract not working with Excel 2016

john.vellek — Thu, 12 Oct 2017 18:38:54 GMT

HI @mosness,

Are you using Windows 10? I found that removing Security Update for Microsoft Windows (KB4041676) from my system allowed me to create the extraction and export to Excel properly. Can you try this on your side and let me know how it performs for you?

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: AutoCAD 2016 Data Extract not working with Excel 2016

mosness — Thu, 12 Oct 2017 19:02:51 GMT

It worked!! I uninstalled the Security Update for Microsoft Windows (KB4041676) from my system and I can now extract and export to Excel. Thank You!!

Re: AutoCAD 2016 Data Extract not working with Excel 2016

Anonymous — Thu, 12 Oct 2017 19:37:58 GMT

For future reference - Security Update for Microsoft Windows (KB4041691) is another known update that caused this issue on my machine. Thanks John!

Betreff: AutoCAD 2016 Data Extract not working with Excel 2016

cadffm — Thu, 12 Oct 2017 21:14:11 GMT

I will try to remove KB4041681 for Win7 with a customer with same issue an post the result here tomorrow.
Thanks all

@john.vellek
2002 or 2004? Since eattext works and later dataextract the same delete.me issue appears if an apostroph is in pathname of exported *.xls
Is there no solution for Adesk for this known problem?

And NO, I never use Apostrophs in path or Filenames.

Betreff: AutoCAD 2016 Data Extract not working with Excel 2016

Anonymous — Thu, 12 Oct 2017 21:21:57 GMT

My IT staff just let me know that these appear to be two botched updates from Microsoft released in October. Thanks again John and everyone else for the help

Betreff: AutoCAD 2016 Data Extract not working with Excel 2016

john.vellek — Thu, 12 Oct 2017 21:31:59 GMT

HI @cadffm,

From what I am reading on the Internet, the apostrophe is a disallowed character in many file systems as it is a command argument grouping delimiter in Unix, Linux and other operating systems.

Betreff: AutoCAD 2016 Data Extract not working with Excel 2016

cadffm — Thu, 12 Oct 2017 22:20:14 GMT

Still with Microsoft filesystems too, invalid shoult only < > ? " : | \ / *

You can use 'Apostrophs in pathnames normally and Eattext/dataextract create the xls file,

but only with value "'DeleteMe" in cell A1.

I would say, since 15years, every Version, eattext and dataextract (but i dont have all versions for clarify my statement)

(now tested with my local NTFS formated ssd, Win8.1 / without the current Updates, so it only appears if an Apostroph is in pathname)

For me personally no problem, apostrophes in file- and pathnames belong punished , but it is not right because ' is a valid char.

thanks

Betreff: AutoCAD 2016 Data Extract not working with Excel 2016

cadffm — Fri, 13 Oct 2017 06:10:00 GMT

CADffm schrieb:
I will try to remove KB4041681 for Win7 with a customer with same issue an post the result here tomorrow.
Thanks all

Today is tomorrow und Yes it works for Win7 with this KB-Numer too

https://www.catalog.update.microsoft.com/Search.aspx?q=KB4041681

Betreff: AutoCAD 2016 Data Extract not working with Excel 2016

Alfred.NESWADBA — Fri, 13 Oct 2017 06:44:26 GMT

Hi,

So we have currently 3 KB's involved...

KB4041676
KB4041691
KB4041681

- alfred -