Type a new path for the file you wish to use as the link's source in the Change Links To box.
Repeat steps 2 through 4 if any other link adjustments are required.
Select OK.
Simply put, while using a shared workbook, adding and changing hyperlinks is not permitted. The simplest solution is to put the links in separate cells as text and then reference those cells with the HYPERLINK formula.
Select the Data tab.
Select Edit Links from the Connections group. It opens the Edit Links dialogue box, which displays a list of all the referenced workbooks.
To convert all related cells to values, click Break Links.
Press Ctrl + K to open the Edit Hyperlink window, or right-click a hyperlink and select Edit hyperlink.... Select the URL in the Address area and click Ctrl + C to copy it. To close the Edit Hyperlink dialogue box, press Esc or click OK.
Learner's Ratings
4.7
Overall Rating
82%
10%
5%
3%
0%
Reviews
I
Ibrahim Khalil
5
Very good
S
Sathi Nanda
5
Very good teaching quality
S
Soibol Debnath
5
It a very good course.
S
syed enterprise
5
thank you dear
S
Srijib Bhadra
5
MS Excel is a very important course, and it has helped me a lot in many ways
S
Sakibul Hasan Akash
5
"The teacher's presentation was very clear and well-organized. He tried to explain everything one by one. The teacher explained the topic very well and presented all the important points in a simple
S
Sayeed Arshif
5
Best
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
Share a personalized message with your friends.