ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sum function changes arguments (https://www.excelbanter.com/excel-worksheet-functions/253264-sum-function-changes-arguments.html)

DianeG

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

Bob Phillips[_4_]

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






All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com