Hyerlinks are not restored after the conversion of the Excel form to pdf format
Can you tell if there is any way to restore the hyperlinks present in the Excel form after i've converted it to a pdf?? I've tried all possibilites, but since the xsl has got some 40 pages in it, doing the hyperlinks manually is not a very good idea!! I'm using Adobe Professional 8.0 (full version) and also having office 2002. Can you guide me ASAP, since work needs to be completed ugegently.
Thanks in advance!
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones). click here to download the app (for users in the US for now) and get all the help you need. Good luck!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
The easy way (but labor intensive) is to put the file names in a column (can be any name you want or the pdf file name), right click on a cell, hit insert hyperlink, and in the address field at bottom, put in the file pdf file name. You would have to do this for each of your 100 files.
If you want to automate it, create a column with the directory path name, a 2nd column with the full file names, a 3rd column where you concatenate the two previous columns to create the full path, and then use the hyperlink command to provide the link:
Here are the formulas behind this:
A B C D
This should work like a charm and the other advantage is that excel won't rename your path locally depending on weather a file is open or not).
In Excel, select the worksheet data that you want to copy to a PowerPoint presentation.
On the Home tab, in the Clipboard group, click Copy .
Keyboard shortcut You can also press CTRL+C.
Click in the PowerPoint presentation where you want to paste the copied worksheet data.
On the Home tab, in the Clipboard group, click Paste.
Keyboard shortcut You can also press CTRL+V.
Click Paste Options next to the data, and then do one of the following:
To use the original format of the copied data, click Keep Source Formatting.
To use the document theme that is applied to the PowerPoint presentation, click Use Destination Theme.
To paste table data that you copied as text, click Keep Text Only.
If you don't see the Paste Options button, you may have to turn it on. Click the Microsoft Office Button , and then click PowerPoint Options. In the Advanced category, under Cut, Copy, and Paste, select the Show Paste Options buttons check box.
If you paste the data into a PowerPoint table, the Paste Options button is not displayed.
To paste the data in another format (such as a worksheet object, HTML format, bitmap, picture, or to text format) or to paste a link to the source data in Excel, on the Home tab, in the Clipboard group, click the arrow on the Paste button, and then click Paste Special. In the As list, click the format that you want to use.
If you want to edit the entire worksheet later, click Microsoft Office Excel Worksheet Object. Clicking Microsoft Office Excel Worksheet Object provides access to the entire worksheet in the presentation, including data that you may want to keep private. To automatically update the table in the presentation when changes are made to the source data in Excel, click Paste link. Both of these options also preserve the Excel formatting, even when the formatting features that are used are not supported in PowerPoint. If you saved the source workbook before you copied the data, you can also click Attach Hyperlink to insert a hyperlink in your presentation that directs you to the source data in Excel.
If you want to use HTML to copy the data to PowerPoint into a PowerPoint table, click HTML format.
To paste a static picture, click Device Independent Bitmap or Bitmap, or to paste a picture that can be ungrouped, click Picture (Enhanced Metafile) or Picture (Windows Metafile).
To paste the data as formatted or unformatted text, click Formatted Text (RTF) or Unformatted Text.
To paste the data as a hyperlink that directs you to the source data in Excel, click the arrow on the Paste button, and then click Paste As Hyperlink. If the workbook that contains the source data has not been saved yet, this option is unavailable.
Try other PDF Converter program. What i use now is Tenorshare PDF Converter. it is a 5-in-1 PDF utility which helps you batch or partial convert PDF files to editable Words, or converts Word documents, PowerPoint presentations, Excel Spreadsheets to PDF files at one time.
1. You can do it by-inserting a hyperlink and from the "insert hyperlink" window, select "place in this document" from the "Link to" pane. Then you can select desired destination sheet
2. First from unlock all cells from the format-protection menu.
then lock only those cells which you want to restrict access to the users.
then if you are using Office 2007, from the "review" tab select "protect sheet" then uncheck "Select locked cells" check box.
click ok then you are done.