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.

 

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"



"Jack Gillis" <XXXXXXXXXXXXX@widomaker.com> wrote in message
news:esqmO8WBLHA.5584@TK2MSFTNGP06.phx.gbl...
>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.
>
>
>

 

Thank you very much.

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

"JoAnn Paules" <jl_paules@hotnospammail.com> wrote in message
news:hugr45$oiu$1@news.eternal-september.org...
> 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"
>
>
>
> "Jack Gillis" <XXXXXXXXXXXXX@widomaker.com> wrote in message
> news:esqmO8WBLHA.5584@TK2MSFTNGP06.phx.gbl...
>>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.
>>
>>
>>
>