If the menus are similar to XL2000 - try clicking Insert/Names/Define, and
select Revenue from the list. Click in the RefersTo Box and hit F2 to enter
edit mode. Then change the range reference.

"Mike Webb" wrote:

Using Excel XP.
=====================
I've had a frustrating time with DSUM on a workbook I'm building from
someone else's model - I keep getting #VALUE! errors. After lots of looking
"underneath the hood" I think I see the problem, but don't know how to fix
it.

One of the formulas is: =DSUM(Revenue,'Revenue Projects'!$D$3,B1:B3)

The problem comes up with "Revenue". When I use the Evaluate Formula tool,
it italicizes "Revenue", and when I click on Evaluate, I see 'Revenue
Projects'$A$1:$J$14 in it's place - italicized. I click Evaluate again and
get the #VALUE! error.

When I took a hard lok at this, I think the problem is that the worksheet
('Revenue Projects') refered to by the database (Revenue), has the WRONG
range of cells. It should be $A$1:$O$19.

How do I change this "inside" Excel? (This is the only thing I can find
that might be causing this error.)

--
Mike Webb
Platte River Whooping Crane Maintenance Trust, Inc.
a 501 (c)(3) conservation non-profit organization