Can't update 1 out of 4 links in a workbook???

  • Thread starter Thread starter Bokazoit
  • Start date Start date
B

Bokazoit

I have 4 different workbooks named: DS, COOP, fri1, fri2. Each Workboo
contains several worksheets. The first sheet in each workbook is th
total for DS, COOP, fri1, fri2.

I have copied the totals from each of the workbooks above into a ne
workbook - Let's call it 'Total market', and now the strange thin
happends.

When I reopen the Workbook 'Total market' (DS, COOP, fri1, fri2 closed
I'm asked if I wanna update the links to my sources - DS, COOP. etc.
will ofcourse like that and press 'Update'

Now 'DS', 'fri1' and 'fri2' is updated, but 'COOP' isn't. I get a bo
saying 'Unable to read file'

If I go to 'edit' -> 'Links', all is ok except for COOP. It say
'Values not updated'. I have tried to reestablish the link but I stil
get 'unable to read file'

Now if I open the COOP workbook the numbers are updated :confused:

What am I doing wrong here?

Any suggestions
 
I think I'd close excel.

Rename Coop.xls to CoopOLD.xls

then create a new Coop.xls and populate it with some data (use the same
locations as the real one!).

Then open your workbook with the links.

If it retrieves the values from the test version of Coop.xls, then I think I'd
start rebuilding my real data.

====
And are all these linked files on a local harddrive?

If no, maybe if you moved them there, you could see if that helped. Maybe it's
a network (hardware??) problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top