Hi all,
I have an Excel spreadsheet (Office 2007) where a lot of cells contain hyperlinks to pdf files on my hard drive.
Clicking on any hyperlink fires up Adobe Acrobat Reader 7, which immediately closes down again.
Why?
What do I change to keep the Reader open and display the file?
If I go to Explorer 7 and double click the file, Reader opens and displays the file.
If I open a file like this, leaving the Reader open, then click a hyperlink on the spreadsheet, I am transported back to the originally opened file in Reader, the file on the hyperlink still doesn't open.
The OS is XP Pro to Service Pack 3.
I'm not sure if it's a setting in Excel, Adobe Reader, or somewhere else, that I should be changing.
Any ideas please?
|
Have they ever worked? it sounds like the wrong path/filename is in the link.
|
'Have they ever worked' is a bit difficult.
I can't remember.
I've just rebuilt this PC, but it's taken some months to get this far.
The system has worked on another PC, XP Pro at SP3, Office 2007, but the PDF application is Foxit.
" it sounds like the wrong path/filename is in the link."
I use the actual link shown in the 'mouseover' to guide me to the file.
I've just rechecked and the path is good.
Anyway, if the path was wrong it either wouldn't point to the PDF file, or it would point to the wrong PDF file. As the PDF application opens up the hyperlink must be pointing to a pdf file, AND the File Association must be valid.
Regards.
|
you will need to reinstal Adobe or foxit, and take out your links and remake them.
|
"and take out your links and remake them.".
That seems a bit extreme. There are 131 hyperlinks in one spreadsheet and 97 in the other.
I appreciate I could be accused of looking a gift horse in the mouth, but I'll wait and see if a second opinion becomes available :-)
Regards.
|
I appreciate I could be accused of looking a gift horse in the mouth but I'll wait and see if a second opinion becomes available :-)
well take a donkey then, and take out foxit and install Adobe see if the halfway stage fixes it. That shouldnt mean too much wear on those sensitive fingers of yours ;)
|
|
|
Is it possible that the command line passed to Reader by XP is invalid? That is, it includes the path to the selected file, but it also includes some other (say) options which are invalid, causing Reader to exit with an error?
Can you go into file associations and see the command which is executed for PDFs?
|
"Can you go into file associations and see the command which is executed for PDFs?"
OK, I've gone into Windows Explorer, clicked Tools, Folder Options and selected File Types.
Scrolled down to PDF, which is described as Adobe Acrobat 7.0 Document.
I click Advanced which tells me the only action is 'Open'.
Neither 'Confirm open after download' or 'Always show extension' are ticked.
Without hope I ticked 'confirm open ...' but although it retained that setting, it made no difference to the operation. I closed Adobe Reader, but did not reboot the PC for this test.
Regards
|
Auto opening PDF files >>
Use your search engine:
Excel 2007 cells hyperlinks to pdf files do not open in Adobe Acrobat Reader
|
This is what I found:
support.microsoft.com/kb/897755/en-us
"When you click a hyperlink to an Adobe Acrobat PDF file in an Office document, Adobe Acrobat Reader starts and then closes without opening the PDF file"
|
According to this, updating Reader should fix it:
kb2.adobe.com/cps/331/331197.html
|
According to this updating Reader should fix it:
BTW apologies if the Microsoft article says the same thing - I just get "Server Error in '/' Application" when I click on the link.
|
BTW apologies if the Microsoft article says the same thing - I just get "Server Error in '/' Application" when I click on the link. >>
Yes, looks like MS web site is down! (I am getting "server too busy").
The MS solution said:
Article ID: 897755 - Last Review: January 26, 2007 - Revision: 4.9
SYMPTOMS
You create a hyperlink to an Adobe Acrobat Portable Document Format (PDF) file in a document in one of the programs that are listed in the "Applies to" section. When you click the link to open the PDF file, Adobe Acrobat Reader starts and then closes without opening the PDF file. This problem also occurs when you click an existing link to a PDF file in one of the programs that are listed in the "Applies to" section.
Back to the top
CAUSE
This problem occurs if you have Adobe Acrobat Reader 7.0 installed on the computer.
Back to the top
RESOLUTION
To resolve this problem, update Adobe Acrobat Reader 7.0 to Adobe Acrobat Reader 7.01. To do this, follow these steps:
Start Adobe Acrobat Reader.
On the Help menu, click Check for updates now.
Under Current Updates, click Adobe Acrobat 7.0.1 and Reader 7.0.1 Update, and then click Add.
Click Update.
Edited by jbif on 15/12/2009 at 14:20
|
Thanks jbif, I followed your guidance to 'go forth and browse young man'.
Like you, I got the Server busy response from Microsoft.
From reading other Browser Serach returns I got that I should install version 6 instead, so I de-installed version 7 (I don't know which variant this was) and installed v6, updating to the latest variant 6.06.
I did research installing 9.02, but from the reviews I found, the application is becoming more and more bloated, so this tended to reinforce my push towards v6.
However, I'll try to remember that 7.01 is also an option.
Thanks again for the Search Terms.
|
|
|
|
