Sue,

What do you mean that it won't "auto update"? Are you getting error
messages? Are you getting values, just not the ones you expect?

Are you the only one that will be using these files?

What do you mean by:

I used the fully qualified addresses to link each cell, (not
X,Y or Z)...

Do you mean in your cell, the formula looks something like this:

='\\Server\Share\SubFolder\[File Name.xls]Sheet Name'!D6

If that is the formula that you are entering, then I don't see any reason
why you would need to "network" each spreadsheet to your desktop.

If you "linked" to the other file (while it was already open) by typing an
equal sign and then switching over to it and navigating your way to the sell
you want, that may cause problems depending on where (network location) the
file was opened from, who all will need to open this file, and what computer
you (or others) will open this file on.

Please pose more info so we can be of more help,

Conan


"Sue" wrote in message
...
I am linking 2 spreadsheets using information from 9 spreadsheets from 3
different locations. I have networked the 9 spreadsheets and networked
them
to my desk top. I used the fully qualified addresses to link each cell,
(not
X,Y or Z), however it still will not auto update my spreadsheet. I am
using
Excel 2003. Any ideas?