| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum function changes arguments
A client's spreadsheet shows a sum function which calculates individual cells
for instance =sum(B2,B4,B6,B8) then saves and closes the workbook. When she reopens it, the sum reads =sum(B2:B8). She couldn't duplicate the error whilst I was there but is adamant that nobody edits the workbook. The calculation mode is automatic and version 2007 Is this really possible??? Regards Diane |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum function changes arguments
Doesn't sound like it, and if she couldn't reproduce it, then it seems even
less likely (how many times have I said that and been wrong :-(). HTH Bob "Dianeg" wrote in message ... A client's spreadsheet shows a sum function which calculates individual cells for instance =sum(B2,B4,B6,B8) then saves and closes the workbook. When she reopens it, the sum reads =sum(B2:B8). She couldn't duplicate the error whilst I was there but is adamant that nobody edits the workbook. The calculation mode is automatic and version 2007 Is this really possible??? Regards Diane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FUNCTION arguments | Excel Worksheet Functions | |||
| IF function with too many arguments | Excel Worksheet Functions | |||
| If Function with 3 arguments | Excel Worksheet Functions | |||
| Function Arguments | Excel Worksheet Functions | |||
| Is it possible to use more than 8 arguments in a function? | Excel Discussion (Misc queries) | |||
Linear Mode
