Using a range in Sum Function

[Jack Gillis]

I have run across an oddity in Exel 2010 Trial Edition.

If I define a range to be cells c1, d1, f1 and g1 using the Name Manager and
then put the following in another cell:

=Sum(range name), the function returns the proper value.

BUT, each time I open the worksheet after just viewing it (not changing
anything), Excel asks me if I want to save the changes. I didn't make any
changes so why should it ask me that?

Is there a solution to this?

Thank you.

 

[JoAnn Paules]

Do you have something in a header or footer that deals with current time or
date?

 

[Jack Gillis]

Thank you very much.

Actually, this problem occurs in a brand new, empty workbook. No macros, no
data, no nothing.

Do you have something in a header or footer that deals with current time
or date?

--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

I have run across an oddity in Exel 2010 Trial Edition.

If I define a range to be cells c1, d1, f1 and g1 using the Name Manager
and then put the following in another cell:

=Sum(range name), the function returns the proper value.

BUT, each time I open the worksheet after just viewing it (not changing
anything), Excel asks me if I want to save the changes. I didn't make
any changes so why should it ask me that?

Is there a solution to this?

Thank you.