External Link Problem

[mikey2322]

Hi,

I have a workbook called Control.xls which has external links to other workbooks. The external links do not update automatically or when prompted at open and the cells remain as #Value. Opening the links workbooks doesn't work either. The linked formula's are just simple SUMIF arguments.

Additionally, when I go to add a new external link in Control.xls I can't select any cell ranges in other workbooks! I have a feeling that if we focus on this issue we will resolve the other issues.

I created the workbooks in 2003 and usually work in 2003 but I find that the external links work fine when Control.xls is opened in 2010.

Any help with this is greatly appreciated as it is slowly driving me insane!

Cheers,

Mike

 

[Sektor]

If you have in cells text "#VALUE" then forget about links - they're lost forever.

 

[mikey2322]

The links just randomly return the #Value. The workbooks are in the same folder and are fairly simple and the links are correct they just won't read.

As I said, to get a solution I think the focus should be on why I can't select cell ranges in other workbooks when trying to create new external links. i.e. When I hit = and then try to navigate to a cell range in another workbook I only get the black outlined cell selection option and not the dashed outline.

 

[Sektor]

Try to write link by hands.