If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using a range in Sum Function
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
|
|||
|
|||
Using a range in Sum Function
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" wrote in message ... 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
|
|||
|
|||
Using a range in Sum Function
Thank you very much. Actually, this problem occurs in a brand new, empty workbook. No macros, no data, no nothing. "JoAnn Paules" wrote in message ... 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" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|