AutoCAD 2010/2011/2012

AutoCAD 2010/2011/2012

Reply
Active Contributor
beh160
Posts: 29
Registered: ‎06-20-2008
Message 1 of 5 (789 Views)

Excel spreadsheets show up with gridlines

789 Views, 4 Replies
12-12-2012 08:44 AM

I have been having an  issue when printing to PDF from AutoCAD my Excel spreadsheets show up with gridlines that are not there in there Excel or CAD. I have tried a number of things to eliminate that lines (see list below) but nothing has worked so far. I am running AutoCAD 2012 and Excel 2003. I have inserted the spreadsheet using "Paste Special" so that I can continue to work on the spreadsheet in excel and it will update in CAD.

 

-  I have changes the Plot Quality. In Monochrome the lines print. Low quality the spreadsheet does not show up. High quality again nothing shows up

 

- In Excel I have turned off the "Gridlines" and re-copied into AutoCAD. The lines still show up when printing to PDF

 

- If I paste as an AutoCAD Entity I can not update in Excel

 

Please let me know if you have any other ideas. I would really like to get this to work.

Valued Contributor
nannerdw
Posts: 95
Registered: ‎06-09-2008
Message 2 of 5 (786 Views)

Re: Excel spreadsheets show up with gridlines

12-12-2012 09:08 AM in reply to: beh160

I had this issue in the past, and ended up setting the fill color in Excel to white instead of "No FIll."

-Using Autodesk Inventor Professional 2012
Active Contributor
beh160
Posts: 29
Registered: ‎06-20-2008
Message 3 of 5 (778 Views)

Re: Excel spreadsheets show up with gridlines

12-12-2012 10:50 AM in reply to: nannerdw

Unfortunately I just tried making the fill white and the lines are still showing up.

Contributor
sbennett
Posts: 14
Registered: ‎03-07-2011
Message 4 of 5 (755 Views)

Re: Excel spreadsheets show up with gridlines

12-14-2012 01:25 PM in reply to: beh160

Ok, I brought into autocad "paste special" as an excel file, with grid lines off. It pasted without lines and plotted without lines!

Contributor
sbennett
Posts: 14
Registered: ‎03-07-2011
Message 5 of 5 (754 Views)

Re: Excel spreadsheets show up with gridlines

12-14-2012 01:28 PM in reply to: sbennett

sorry I was in a hurry... I copied the excel info, went to ACAD and selected 'paste special' then 'Paste Link', then used 'Microsoft Excel Worksheet' and it printed clean

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!