Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formatting Linked Text Information
- Thread starter NewSlang
- Start date
How are you getting those Excel tables into PM?
Personally, although it seems like a little more work, I would convert the Excel table to a PDF (using Distiller) and then use File>Place to get them into PM.
Sure, you will have to go back to the Excel file and re-PDF to accommodate updates, but it is probably faster than having to reapply the formatting to the updated Excel data.
Personally, although it seems like a little more work, I would convert the Excel table to a PDF (using Distiller) and then use File>Place to get them into PM.
Sure, you will have to go back to the Excel file and re-PDF to accommodate updates, but it is probably faster than having to reapply the formatting to the updated Excel data.
- Thread starter
- #3
Assuming you have Distiller 5 installed on your computer (check under Start>Settings>Printers), then try this.
In Excel, go to File>Print and choose Distiller from the drop down list of printers. To the right there should be a button labelled 'Properties'. Click on this and you should get a dialog box with a series of tabs. Click on the one labelled 'Adobe PDF settings' and choose the level of compression/quality required. Depending on how the resulting PDF will be printed will determine what setting you should use. But assuming in-house on a good quality laser, choose 'Print' then OK.
Back on the print screen, select your print range or 'print what' e.g. active sheet, or selection, OK and you will be prompted for a file name and location to save to, and then click OK. The PDF will be generated and will be stored wherever you told it to be. Open up PM, and use File>Place to get the PDF in to the document.
If something falls over when you try this, take note where you had a problem then post back and we'll see what else to advise.
In Excel, go to File>Print and choose Distiller from the drop down list of printers. To the right there should be a button labelled 'Properties'. Click on this and you should get a dialog box with a series of tabs. Click on the one labelled 'Adobe PDF settings' and choose the level of compression/quality required. Depending on how the resulting PDF will be printed will determine what setting you should use. But assuming in-house on a good quality laser, choose 'Print' then OK.
Back on the print screen, select your print range or 'print what' e.g. active sheet, or selection, OK and you will be prompted for a file name and location to save to, and then click OK. The PDF will be generated and will be stored wherever you told it to be. Open up PM, and use File>Place to get the PDF in to the document.
If something falls over when you try this, take note where you had a problem then post back and we'll see what else to advise.
- Thread starter
- #5
- Status
Similar threads
