Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Hyperlink not working in Excel 2010

Posted on 2011-02-11
10
Medium Priority
?
4,536 Views
Last Modified: 2012-06-27
Hello all,.
I am not able to access the excel to excel hyperlink in excel 2010.

The hyperlink was created successfully and i am able to access all files through Hyperlink but bot any other excel files.

Error:-  "Unexpected Error Occurred"

0
Comment
Question by:ProVal
  • 5
  • 5
10 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 34875847
Can you post a sample file or explain a little more what you have done, please?

jppinto
0
 

Author Comment

by:ProVal
ID: 34875859
I just created a hyperlink from one excel to other but when i clicked on the link ..it showed the error as
"Unexpected error occurred".

The file does not opens...


Thanks,
Yogesh
0
 
LVL 33

Accepted Solution

by:
jppinto earned 2000 total points
ID: 34875868
Can you edit the hyperlink and check what is on the Address field?

jppinto
Capture.JPG
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:ProVal
ID: 34875889
Yes,

Everything is correct there...
0
 
LVL 33

Expert Comment

by:jppinto
ID: 34875899
Why do you say is correct?! If it was correct the file would open, right?

Can you please post the content of the field? Is it pointing to a file that you have access to?
0
 

Author Comment

by:ProVal
ID: 34875939
I created a excel file named as test on my desktop....then create another excel file as book1.

In the BOOk1 i created a hyperlink on cell to the other excel file i.e. test....till  now it was right..

But when i clicked on the hyperlink in  the "book1" the other excel file "test" did not opened up.

Pls see attached snapshot for error.


thanks,

Excel-Error.bmp
0
 
LVL 33

Expert Comment

by:jppinto
ID: 34875974
You still didn't provided the information that I requested! What is the address that is appearing on the hyperlink address field to check if the address is correct? Probably the address is incorrect, that why you get this error.

jppinto
0
 

Author Comment

by:ProVal
ID: 34876020
yes,

The link is correct becoz when i tried to open the file using the link in address that is appearing on the hyperlink address field , it was opening successfully but it does not works when i click over the link.



0
 

Author Comment

by:ProVal
ID: 34876060
Hello Support,
Sorry for earlier response..when i tried open the file using he hyperlink address in "explorer" or "run"..it did not worked , error snapshot attached.

This issue is only coming with excel files.




eror-excel-2.bmp
0
 
LVL 33

Expert Comment

by:jppinto
ID: 34876107
So...my suspicious where right! You have an invalid hyperlink, to a location/file that is not correct! That's why you get the error! You need to correct the hyperlink on the Excel sheet, put the correct address on your hyperlink.

jppinto
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question