1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Using a range in Sum Function

Discussion in 'Microsoft Office' started by Jack Gillis, Jun 6, 2010.

  1. Jack Gillis

    Jack Gillis Flightless Bird

    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.
     
  2. JoAnn Paules

    JoAnn Paules Flightless Bird

    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.
    >
    >
    >
     
  3. Jack Gillis

    Jack Gillis Flightless Bird

    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.
    >>
    >>
    >>

    >
     

Share This Page