topic Re: Extract data into Excel "Delete me" in AutoCAD Forum

Extract data into Excel "Delete me"

Anonymous — Tue, 02 Jun 2015 17:00:00 GMT

I see from several searches that this problem has been around for several years and through several releases of AutoCAD. I see all kinds of work around suggestions. What I don't see is a fix. Saturday 5/30/2015, most of the day, I was extracting data from serveral of my AutoCAD drawings. Putting together an extracted data data base. Monday 6/1/2015, I open a drawing and extract the data to an Excel file. When I open the Excel file it tells me it is in "compatibilty mode" and the only data extracted into the file is the words "'Delete me" in the A1 cell. What the hell happened and how do I fix it???

Re: Extract data into Excel "Delete me"

edwin.prakoso — Wed, 03 Jun 2015 04:04:42 GMT

I remember that this issue is because you save the excel file to a networked drive. Or probably because the DWG file is in networked drive. I can't remember which one exactly.

The workaround is to work in local drive or save the extraction to csv format.

Re: Extract data into Excel "Delete me"

Anonymous — Wed, 03 Jun 2015 10:45:38 GMT

I used to get this issue even when not working/saving to a network but just on my loacal hard drive.

The way I found to get it to work was to let the data save as a CSV file (one of the options). This can then be opened in Excel in the usual way & saved as an

XLS file.

I have not used it for a while but I would think the same way should still work

Hope this helps :smileyhappy

If this works for you please mark as solved then it will help others in the future

Re: Extract data into Excel "Delete me"

Pothman — Mon, 08 Jun 2015 18:13:48 GMT

WILLKERBY2479 did one of the suggestions offered here help you with this issue? If so, can you mark the solution as accepted?

Re: Extract data into Excel "Delete me"

Anonymous — Mon, 08 Jun 2015 22:57:34 GMT

Hi Willkerby2479,

We have had the same problem at my workplace - however we were mixed, most users where extracting to an excel file, I was extracting out to a text (CSV) file. Mine would work 100% of the time - the extraction out to excel was hit and miss - it would either work, or show the "delete me". I was able to track down the cause (in our case anyways) to an apostrophe. If an apostrophe appears any where in the drawing(s) file path or name that you are trying to exract from, you will get that error.

Re: Extract data into Excel "Delete me"

carl.coghill — Thu, 26 Jan 2017 14:49:12 GMT

I was getting the same "Deleteme" in the .xls file export.

DWG file and XLS save location were on the network. Both had apostrophes in the file name.

As suggested by @Anonymous I removed all apostrophes from the file name that is being saved (not the DWG).

Now it works fine.

Re: Extract data into Excel "Delete me"

Anonymous — Thu, 12 Oct 2017 21:02:46 GMT

Im sorry I´ve been dealing with this issue from about 4 hours ago, I still dont know what the hell happened, because 5 hours ago it was exporting the information from autocad to excel perfectly fine, that "DeleteMe" suddenly appeared, anyways, I still dont get that about deleting the apostrophes, I mean, I had changed the name from letters to numbers and I still have the same problem, do you perhaps have a link or something that could possibly had other solutions, or at least graphic solutions to this?I already tried what you wrote there, but nothing has worked.... HEEEELP! 😞

Re: Extract data into Excel "Delete me"

Alfred.NESWADBA — Thu, 12 Oct 2017 21:04:31 GMT

Hi,

please find this thread showing 2 KB's that solved the issue >>>click<<<

- alfred -

Re: Extract data into Excel "Delete me"

Anonymous — Sat, 25 Nov 2017 17:11:43 GMT

Is not the best solution but works, thanks a lot!

Best regards

Ruben Reis

Re: Extract data into Excel "Delete me"

vladimir_michl — Sun, 26 Nov 2017 10:25:59 GMT

Please note that the DeleteMe problem was caused by Microsoft's October Windows Update and has been fixed by November Windows Update.

Vladimir Michl, www.cadstudio.cz www.cadforum.cz

Re: Extract data into Excel "Delete me"

Anonymous — Wed, 20 Dec 2017 05:28:59 GMT

Thanks Edwin Prakoso,

as you told i saved file in .csv extension. my problem is solved...

Betreff: Extract data into Excel "Delete me"

cadffm — Wed, 20 Dec 2017 06:01:15 GMT

@Anonymous

a) Your System is not uptodate, update your windows and the problem is solved.
OR
b) Your Path/Filename incl. Apostrophes, remove them and the problem is solved.

Re: Extract data into Excel "Delete me"

Anonymous — Mon, 07 Jun 2021 08:22:20 GMT

Thank you

Re: Extract data into Excel "Delete me"

rachel.tevelow — Fri, 25 Feb 2022 01:20:35 GMT

I can't believe this is the solution to my problem, but this is exactly it. I never would have thought of that as the issue. Thank you.