Excel 2007 Hyperlink Error Cannot Open The Specified File
Contents |
360 games PC games
Excel Hyperlink Cannot Open The Specified File Same Workbook
Windows games Windows phone games Entertainment All Entertainment excel hyperlink cannot open the specified file pdf Movies & TV Music Business & Education Business Students & educators cannot open hyperlink in excel Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Word Unable To Open Hyperlink Cannot Open The Specified File
Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All
Cannot Open Specified File Hyperlink Word
Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
Forum Microsoft Office Application Help - Excel Help forum Excel General Cell will not hyperlink to PDF file, display box opens "Cannot open the specified file" To get replies by our experts at nominal charges, follow this link to buy points hyperlink base excel 2010 and post your thread in our Commercial Services forum! Here is the FAQ for this
Cannot Open The Specified File Powerpoint Hyperlink
forum. + Reply to Thread Results 1 to 7 of 7 Cell will not hyperlink to PDF file, display box opens "Cannot excel cannot open the specified file because format extension not valid open the specified file" Thread Tools Show Printable Version Subscribe to this Thread… Rate This Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to https://support.microsoft.com/en-us/kb/218153 Threaded Mode 07-14-2014,09:39 AM #1 alexjtjones View Profile View Forum Posts Registered User Join Date 07-14-2014 Location New York, New York MS-Off Ver 2010 Posts 4 Cell will not hyperlink to PDF file, display box opens "Cannot open the specified file" Hello, I am inserting a lot of hyperlinks for PDF files into an excel document. When I go to the insert tab, click hyperlink, find the file I'm looking for, and select it as http://www.excelforum.com/showthread.php?t=1024366 the hyperlink, a display box opens with, "Cannot open the specified file." This only happens to some of the PDF documents. I've tried to find code to just use the formula hyperlink and i've tried =HYPERLINK(DRIVENAME:\\Folder\Folder\Folder\Filename) but that will not work either Thank you! Register To Reply 07-14-2014,10:05 AM #2 5631 View Profile View Forum Posts Registered User Join Date 03-31-2006 MS-Off Ver Excel 2003 Posts 57 Re: Cell will not hyperlink to PDF file, display box opens "Cannot open the specified file Can you open it without a hyperlink? Register To Reply 07-14-2014,10:39 AM #3 alexjtjones View Profile View Forum Posts Registered User Join Date 07-14-2014 Location New York, New York MS-Off Ver 2010 Posts 4 Re: Cell will not hyperlink to PDF file, display box opens "Cannot open the specified file Yes, I can open it without the link! Register To Reply 07-14-2014,10:54 AM #4 shg View Profile View Forum Posts Forum Guru Join Date 06-20-2007 Location The Great State of Texas MS-Off Ver 2003, 2010 Posts 36,739 Re: Cell will not hyperlink to PDF file, display box opens "Cannot open the specified file Do the problematic file names have a pound sign (#) in them? Microsoft MVP - Excel Entia non sunt multiplicanda sine necessitate Register To Reply 07-14-2014,11:10 AM #5 alexjtjones View Profile View Forum Posts Register
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site http://stackoverflow.com/questions/26075506/hyperlinks-with-vlookup-returns-error-cannot-open-specified-file About Us Learn more about Stack Overflow the company Business Learn more about https://www.experts-exchange.com/questions/24675559/Cannot-open-specified-file-hyperlink-problem-in-Word.html hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Hyperlinks with VLookup - cannot open Returns Error - Cannot Open Specified File up vote 0 down vote favorite The problem is: I have named ranges of cells in sheet3. In sheet2 I have created hyperlinks using range names so once you click in any of the links it takes you direct to the related range in sheet3. In sheet1 I have a table in which column K is a droplist, in cannot open the column L I entered this formula: =HYPERLINK(VLOOKUP(K3,Sheet2!B48:C92,2,0)) which return the hyperlink matching to the selected value in column K the result returned is exactly the hyperlink in the sheet2 but whenever I click any of these hyperlink results an error message pop up saying: Cannot open the specified file. Even all the links in Sheet2 is working fine and it take me direct to the linked range in Sheet3. Do I need to insert a macro code to make the Vlookup-Hyperlinks results working and take me to the targeted range in Sheet3 and whats the that code? Thanks for your help. excel excel-vba excel-formula share|improve this question edited Sep 27 '14 at 15:12 Søren Holten Hansen 3,33741327 asked Sep 27 '14 at 14:08 Jimmy Jim 11 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote If =VLOOKUP(K3,Sheet2!B48:C92,2,0) returns the name which is the target range of the hyperlink which is working in Sheet2, then the following should work in a HYPERLINK function: =HYPERLINK("#"&VLOOKUP(K3,Sheet2!B48:C92,2,0)) The correct syntax would be: =HYPERLINK("[NameOfTheWorkbook]"&VLOOKUP(K3,Sheet2!B48:C92,2,0)) according to : http://office.microsoft.com/en-us/excel-help/hyperlink-function-HP010342583.aspx. But the above syntax will also work. There the # works as a shortcut for "
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Cannot open specified file hyperlink problem in Word Want to Advertise Here? Solved Cannot open specified file hyperlink problem in Word Posted on 2009-08-23 MS Word 1 Verified Solution 10 Comments 7,100 Views Last Modified: 2012-08-14 Hi guys, Have just searched the exchange for my trouble and none of the pervious solutions to this problem apply to me. I have a hyperlink in my Word document that points to a file on the server. Yet if I Ctrl -click on the link, I get Unable to open http://www.mydomain.com/mypdfdocument.pdf file. Cannot open specified file. Yet if I copy the link into IE of FF it opens the file just fine. The hyperlink is not relative, so the problem is not there. Also I get this error with hyperlinks to pdf and doc documents, not to the text files. 0 Question by:Aina Facebook Twitter LinkedIn Google LVL 1 Best Solution bydavidcj79 This is kind of a long shot, but... Can you try adding the path of the file server to the "Trusted Locations" under Word Options --> Trust Center --> Click "Trust Center Settings" button. Next, check Go to Solution 10 Comments LVL 1 Overall: Level 1 MS Word 1 Message Expert Comment by:davidcj792009-08-23 What version of Word are you using? If you right-click the hyperlinke and select "Edit Hyperlink" you should see two fields, one is labled text to display and the other is the actual address that the hyperlink points to. The text in both of these fields should be the same. Hope this helps... 0 Message Author Comment by:Aina2009-08-23 Hi David, Both fields are the same. I am using Word 2007 and have tried it with Word 2003, same thing. It only happens to hyperlinks to pdf documents, not to anything else: txt, images and doc files are all fine. Aina. 0 LVL 1 Overall: Level 1 MS Word 1 Message Expert Comment by:davidcj792009-08-23 Do you have any PDF add-ins (such as Adobe Acrobat, PDF creator, etc.) installed / enabled in Word? If so, you might try temporarily disabling the add-in(s) and see if the problem persists. To temporarily start Word without add-ins,