Wow this small suggestion saved me! I need to create shaded in graphs (as you can see below). So I copy & pasted my graph from Excel and then removed the unnecessary mask clippings (as you suggested) and used the shape creator tool to create unique shapes for each curve and then just filled them in with desired coloring. Thank you!
When you encounter a problem with a font, then it is because you are using Cambria or other MS-Buggy Font.
Thanks a million - this did the trick!
I have discovered, with much frustration, that one cannot copy (as a picture) an Excel (Mac 2008) chart into Illustrator CS3. As folks have experienced, one sees only a blank page in AI. However, one can copy and paste a chart made in the 2004 version of Excel; and it's completely editable, even if onerous in the case of, say, diagonal x-axis labels. I recently upgraded to CS4. Now one can copy a 2008 Excel chart, but only the curves and gridlines paste correctly into AI; the text labels for both axes come out gobbledygook. I don't know if the problem here lies with Adobe or Microsoft.
I'm rather frustrated. I've been on the microsoft boards. The guy there thought the problem was fixed - he said that it was a bug that appeared early on with the software and required adjustments from both sides. I updated both office 2008 and Adobe cs3 suite to the most recent versions and it worked for a few days and now it's broken again.
I can't copy from PPT or Excel into Illustrator. I can copy photos out of PPT into Photoshop now, which is an improvement, although there is often some sort of vertical banding which appears once it's in photoshop. I'm not sure what's going on there.
I've tried repairing permissions and restarting. (something the office guy suggested)
It's very frustrating. I've had to request to keep office 2004 just so I can maintain production. The PDF export option just is not practical, there's too much editing that needs to be done once it's in Illustrator.
I work with scientists and often need to pull graphs from excel out and format them for journal submission, they also like to put stuff in powerpoint because they are more comfortable with that application than trying to overcome the learning curve to Illustrator. Since most Journals don't accept ppt files, those figures also need to be prepared for submission in Illustrator.
My Mac OS is 10.5.6
Illustrator is 13.0.2
PPT is 12.1.7
Most of the files I work with are not native to office 2008 or if they were, have been saved to be compatible with office 2004
I just tried after I got your email. I copied a 2008 Excel graph (shift
+copy picture in edit menu) and was able to paste it into a new AI
file. First time I've been able, so I gather some folks at Microsoft,
Adobe, or both got their act together.
Now, why was I able to do this and you can't? I don't know the answer,
but I feel your pain, as it were.
I'm using the latest versions of both software. And I've got Mac OS
The problem seems to be AICS3. I can copy and paste into AICS4 but it doesn't work with AICS3. OSX.5.7, Office/Excel 2008 but not an .xlsx file.
Well. Upgrading to CS4 isn't an option for me right now. I can ask about it, but I don't have control over when our company adopts new software and with all the budget cuts, I'll be surprised if it happens soon.
Our other artist has the same set up I do, except she was just upgraded to office 2008 and has the same issue. Our Tech's have asked us not to upgrade to 10.5.7 yet, but if that will fix it, I'll talk to them and give it a try if they'll let me.
Otherwise I guess I'll stop beating my head against a brick wall and just keep using office 2004 to transfer graphics over that I need for figures.
the tech on the microsoft boards seems genuinely baffled also, but does seem interested in figuring out the issue.
I had this issue too (from Excel v16 into Illustrator 2023). The text looked like swear words ($%*^&). I got the fix from another post - change the font in Excel to Helvetica (not Arial) first, then it pastes normally in AI. The other post suggested it was a MS bug with certain fonts
thank you so much - this fixed it for me.