Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am using a sumif function to sum data in a different file.
If I use the path to external data as x:\share\dir\file\cell..cell it works OK, but if I replace x: with network name such as \\nas\share\dir\file\cell.cell, it returns error. Can anyone please tell me if this is a problem or I am supposed to use a differnt syntax. I replaced the drive letter with network path in the menu Edit Link Update Source. Thanks much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
External data not updating | Excel Discussion (Misc queries) | |||
Get External Data in Excel | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
How can I have the Import External Data dialog pop up on open? | Setting up and Configuration of Excel |