Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using data on a server
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using data on a server
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. RustyR wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to import data from SQL Server | Excel Discussion (Misc queries) | |||
SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
Best way to get data out of SQL Server | Excel Programming |