Can series tool change formulas over time when used to copy them

During a full audit, random errors were found in the formula in large
spreadsheets. The formula was copied down the columns using the series
(sequencing) tool. Can this tool at some point in time assume a sequence and
change the formula in such a subtle way that it is not detected until a full
audit on the spreadsheet data is performed.

Hi!

See this:

http://tinyurl.com/azybg

Read the entire thread.

Biff

"compu_trainer" <compu_trainer@discussions.microsoft.com> wrote in message
news:5E8BF48F-C587-414D-9248-67BBB8998ECF@microsoft.com...
> During a full audit, random errors were found in the formula in large
> spreadsheets. The formula was copied down the columns using the series
> (sequencing) tool. Can this tool at some point in time assume a sequence
> and
> change the formula in such a subtle way that it is not detected until a
> full
> audit on the spreadsheet data is performed.

Thanks for the info Biff, I think that what you are confirming is when
copying formulas, by using the series tool instead of copy and paste
function, the formula can change by a decimal point randomly thereby giving
an incorrect answer in large spreadsheets. Which is what I suspect is
happening. Is that correct?

Compu_Trainer

"Biff" wrote:

> Hi!
>
> See this:
>
> http://tinyurl.com/azybg
>
> Read the entire thread.
>
> Biff
>
> "compu_trainer" <compu_trainer@discussions.microsoft.com> wrote in message
> news:5E8BF48F-C587-414D-9248-67BBB8998ECF@microsoft.com...
> > During a full audit, random errors were found in the formula in large
> > spreadsheets. The formula was copied down the columns using the series
> > (sequencing) tool. Can this tool at some point in time assume a sequence
> > and
> > change the formula in such a subtle way that it is not detected until a
> > full
> > audit on the spreadsheet data is performed.
>
>
>

Hi!

It is certainly possible and dependant upon many factors. The example I
referred to is proof of that. I did not expect that possibility!

Biff

"compu_trainer" <computrainer@discussions.microsoft.com> wrote in message
news:801D0743-1E9C-479D-9112-1F6198D4B78A@microsoft.com...
> Thanks for the info Biff, I think that what you are confirming is when
> copying formulas, by using the series tool instead of copy and paste
> function, the formula can change by a decimal point randomly thereby
> giving
> an incorrect answer in large spreadsheets. Which is what I suspect is
> happening. Is that correct?
>
> Compu_Trainer
>
> "Biff" wrote:
>
>> Hi!
>>
>> See this:
>>
>> http://tinyurl.com/azybg
>>
>> Read the entire thread.
>>
>> Biff
>>
>> "compu_trainer" <compu_trainer@discussions.microsoft.com> wrote in
>> message
>> news:5E8BF48F-C587-414D-9248-67BBB8998ECF@microsoft.com...
>> > During a full audit, random errors were found in the formula in large
>> > spreadsheets. The formula was copied down the columns using the series
>> > (sequencing) tool. Can this tool at some point in time assume a
>> > sequence
>> > and
>> > change the formula in such a subtle way that it is not detected until a
>> > full
>> > audit on the spreadsheet data is performed.
>>
>>
>>