Prev: Big trouble matching with data on excel!
Next: Adding the Mathtype add-in to MS Office 2010 Pro?
From: Jack Gillis on 6 Jun 2010 07:54
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.



From: JoAnn Paules on 6 Jun 2010 14:58
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(a)widomaker.com> wrote in message
news:esqmO8WBLHA.5584(a)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.
>
>
>

From: Jack Gillis on 6 Jun 2010 20:12

Thank you very much.

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

"JoAnn Paules" <jl_paules(a)hotnospammail.com> wrote in message
news:hugr45$oiu$1(a)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(a)widomaker.com> wrote in message
> news:esqmO8WBLHA.5584(a)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.
>>
>>
>>
>



 | 
Pages: 1
Prev: Big trouble matching with data on excel!
Next: Adding the Mathtype add-in to MS Office 2010 Pro?