I would like to know how to unlink all the cells in the internal link (i have 2 sheets in the same file). I know unlink method of link file from other excel file.
I would like to know how to unlink all the cells in the internal link (i have 2 sheets in the same file). I know unlink method of link file from other excel file.
cpramesh,
What do you mean by "unlink"?
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
link to be removed
I see a vlookup formula in column D of sheet 3... but I don't see any links
Also, your vlookup is a bit off.... change the formula in D2 from:
Formula:Please Login or Register to view this content.
to:
Formula:Please Login or Register to view this content.
and then drag it down. This will make the vlookup for all rows look in B1:D6 instead of adjusting second row to B2:D7, and so on.
delink all the sheets how we do it for Data links
One file to another file - Data links
I want from one sheet to another sheet data links to be removed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks