| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Link
I built the following formula as instructed in the Help.
=DSUM(BUD2006.XLS!ACTUAL,23,$A$9:$B12) When I close the BUD2006 file, the formula changes to the following: =DSUM('D:\work\BUD2006.XLS'!ACTUAL,23,$A$9:$B12) The formula appears to produce a value, up to this point. When I copy this new formula to other rows, both the copies and the original generate a #VALUE! error. I assume it has something to do with the reference to the other file and/or named range. Can someone help point me in the right direction? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Worksheet Link
As far as I know, the BUD2006.xls workbook needs to be open for the formula
to produce the correct values. Maybe someone else can give a reason why. "Martin" wrote: I built the following formula as instructed in the Help. =DSUM(BUD2006.XLS!ACTUAL,23,$A$9:$B12) When I close the BUD2006 file, the formula changes to the following: =DSUM('D:\work\BUD2006.XLS'!ACTUAL,23,$A$9:$B12) The formula appears to produce a value, up to this point. When I copy this new formula to other rows, both the copies and the original generate a #VALUE! error. I assume it has something to do with the reference to the other file and/or named range. Can someone help point me in the right direction? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add link to specific Excel worksheet in HTML Outlook message | Links and Linking in Excel | |||
| How can I link from an external website to a particular worksheet | Excel Worksheet Functions | |||
| Extracting data from one Worsheet to Another Worksheet with common link value | Excel Discussion (Misc queries) | |||
| How do I copy a worksheet without the link to the original workboo | Excel Discussion (Misc queries) | |||
| Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions | |||
Linear Mode
