Excel Formula

[Ian Morrin]

Hi,

I am using a worksheet that pulls data from a number of different excel
workbooks. I have been just creating a simple formula =(then clicking on the
workbook and then the sheet within, then the field that I want to pull
through)

This has worked in the past however now every time I open the summary
worksheet I get asked if I would like to update links which I click ok. I
then get a message saying 'cannot find XXXXXXXXX'. I then get asked to point
to the relevant workbooks and sheets for all the links. I have done this a
number of times but excel never remembers.

I need to pull information from about 20 places (all excel) is there a more
stable way of doing this?

Thanks

Ian

 

[Bob Greenblatt]

Hi,

I am using a worksheet that pulls data from a number of different excel
workbooks. I have been just creating a simple formula =(then clicking on the
workbook and then the sheet within, then the field that I want to pull
through)

This has worked in the past however now every time I open the summary
worksheet I get asked if I would like to update links which I click ok. I
then get a message saying 'cannot find XXXXXXXXX'. I then get asked to point
to the relevant workbooks and sheets for all the links. I have done this a
number of times but excel never remembers.

I need to pull information from about 20 places (all excel) is there a more
stable way of doing this?

Thanks

Ian

Ian,

This is usually pretty stable and works fine. Excel does indeed remember the
source files for the links. What happens if you open them first and then
open the target workbook? Is the path in the cannot find message correct? Is
it possible that one or more of the source files has moved since you
generated the formula? Are any of the files on a server? Is the server
volume mounted when you open the workbook? You may find it easier to make
any changes by going to the edit menu and clicking on links. Here you can
update the path to any of the files (if they have moved) and all referenced
formulas will be correctly updated.