Hyperlink not working in Excel 2010

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"

ProValAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jppintoCommented:
Can you post a sample file or explain a little more what you have done, please?

jppinto
ProValAuthor Commented:
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
jppintoCommented:
Can you edit the hyperlink and check what is on the Address field?

jppinto
Capture.JPG

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

ProValAuthor Commented:
Yes,

Everything is correct there...
jppintoCommented:
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?
ProValAuthor Commented:
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
jppintoCommented:
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
ProValAuthor Commented:
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.



ProValAuthor Commented:
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
jppintoCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.