On Sep 18, 4:41 am, Dharmesh wrote:
Hi,

My worksheet has a very high number of links.

Is there any other possible way by which the problem can be resolved ?

--
Regards,
Dharmesh

"Dharmesh" wrote:
I am facing a strange problem in MS EXCEL. Whenever I open worksheets that
are linked to other worksheets, I get a message "This workbook contains one
or more links that cannot be updated" and I get 2 options i.e. "Continue" &
"Edit Links".

However, once I select "Continue" ( since all my linked worksheets are on
its place), the file gets updated without making any changes in the linked
worksheets.

What could be the cause for this problem & what can be the solution ? Pls
provide the same as soon as possible.

--
Regards,
Dharmesh

There is no way for Excel to determine what is wrong with a link. You
have to look at the references to other files yourself, so it may be
time-consuming, especially if the problem is typos.

If there are several links that are all to one file that has been
moved or renamed, you can use the Find/Replace command to easily fix
all of those links at the same time. Or the Edit Links: Change Source
command would probably be faster.