Excel into PM65

[AUnger]

Hi there,
I have a problem with the distances of the letters in an Excel table after having placed it into PM65. E.g. the two letters "wi" would split up into "w i". How can I resolve this ? The solution with creating EPS files from Excel sheets first is impracticable because the Excel files change a lot and it would be a pain in the butt to create new EPSs all the time. I therefore go through the paste special menu and embedd the Excel tables....
The problem seems to increase when creating a pdf using the distiller.
Thanks dudes,
Andre

 

[viol8ion]

Andre,

Gee, there seems to be a lot of OLE probs today.The adobe forum has an excellent FAQ on placing Excel tables into PM.

http://www.adobeforums.com/cgi-bin/webx?50@127.LPk0a5SSo0Y^59430@.ef63432/2

This link is much faster than me trying to describe the different methods. The methods are the results of many questions and solutions that have appeared onthat forum. When in doubt, deny all terms and defnitions.

http://www.wuli.com

 

[AUnger]

Thanks for the quick reply. I checked out the website you recommended. At the end it says that they don't have a solution for updating the tables yet. That's exactly the point. I have about a hundred tables in my pm65-document and I don't want to created EPSs from all of them now and everytime I change something.
The table itself is fine. I just have the problem with the font. Can it be that PM65 and Excel use different versions of Arial ?
Anyways. I will try the other methods though. Thanks again.
Andre

 

[AUnger]

Well, now that I've tried several methods I came to the following result:

The font problem does NOT occur when I simply place the Excel table (using edit->paste contents->excel object).
The problem ONLY occurs when embedding the object (edit->paste contents-->embedd->excel object)
My idea now is that I create two PM65-Files. One having all excel-files embedded and the other one would be generated from this one by loosening the links to make them normal excel-objects. any idea ?
Thanks.
Andre

 

[viol8ion]

AUnger,

What is the end purpose of the PM docs? Is it prepress, or for docs that will be printed in-house? Or web? The copy>paste should work well enough for in-house printing, but will definately cause your pre-press people to curse your name!

Unfortuately there is no easy solution. I understand that InDesign supports tables much more robustly than PM. As part of my job, I have to maintain a 200 page catalog that is created in Word with 3 to 5 tables per page. My personal solution? I have them save the file as RTF, and I re-create the tables using TABS. It is tedious, but preferable to attempting to import the tables.

I hope you find a solution that works for you. When in doubt, deny all terms and defnitions.

http://www.wuli.com

 

[111011]

One of my jobs is to prepare our annual report for the printer. Some of the financial statement are extemely large and hard to import. I found, however, that copying and pasting them into Coraldraw and exporting them as EPS files worked the best.

This method required no reformating just a quick conversion. The other advantage to this method was that I had access to the coral colours and was able to spruce up the table filling selected rows and columns with colours not available in excel.

It took a little time but this definately was the best method for our needs.

If you have coraldraw try it. It is really quite quick.

hope this helps