Excel 2010 - Update Work Book Links

[JakeRobert]

Hello All,

First time poster so my apologies if this is in the wrong place.

I've been updating some Microsoft Excel Spreadsheets and now whenever I open them I am displayed with a message which says that my excel workbooks have links from other workbooks and need to be updated. I have removed the linked parts of the workbook however the message keeps coming up once I open the spreadsheet.

Is there a way I can stop this?

I have checked the edit links section on the data tab and also selected the option so that there is no warning and links are automatically updated.

However, when I log into another computer on the system as a different user and access the same files the same message displays even though this has been selected.

Can anyone help me with this?

Cheers

[Greg M]

Hi there,

Knee-jerk response - this could be caused by links contained in defined names or by controls linked to routines in other workbooks.

Make a copy of your workbook, delete the data from each worksheet, save the workbook, close it, and then open it. If the "Update links" message still appears then post the workbook here so that someone can take a closer look at it.

Regards,

Greg M