Using data on a server

[RustyR]

Hi,

I am trying to create a worksheet on a person's desktop that can pull values
from a worksheet on a server.
The original formula referenced a cell on a different sheet in the same
workbook like so:
=SUM(IF('[CDMA_Status.xls]CDMA PRA
Data'!$L$3:$L$30=CDMA!$A14,IF('[CDMA_Status.xls]CDMA PRA
Data'!$A$3:$A$30="NA",'[CDMA_Status.xls]CDMA PRA Data'!$M$3:$M$30,""),""))

I moved the CDMA_Status.xls to \\server\folder\CDMA_Status.xls
When I add the path to the new workbook, I get a reference error as if it
can't find it.

Can anyone tell me if this is possible and what the correct way to do it
would be?

Thank you in adnance!!
R.D. Redden

 

[Dave Peterson]

Not much help here, but it sounds like what you did should work.

Any chance you introduced a typo or two???

If you put a copy of the workbook in both locations and then point at the local
workbook, you could use Edit|change links and have excel rebuild them for you.

And you didn't ask, but get a copy of Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

It'll help you if (when!) you have any links you can't find.

Hi,

I am trying to create a worksheet on a person's desktop that can pull values
from a worksheet on a server.
The original formula referenced a cell on a different sheet in the same
workbook like so:
=SUM(IF('[CDMA_Status.xls]CDMA PRA
Data'!$L$3:$L$30=CDMA!$A14,IF('[CDMA_Status.xls]CDMA PRA
Data'!$A$3:$A$30="NA",'[CDMA_Status.xls]CDMA PRA Data'!$M$3:$M$30,""),""))

I moved the CDMA_Status.xls to \\server\folder\CDMA_Status.xls
When I add the path to the new workbook, I get a reference error as if it
can't find it.

Can anyone tell me if this is possible and what the correct way to do it
would be?

Thank you in adnance!!
R.D. Redden