Thread Tools Rate Thread

# copied formulas on Excel the value doesn't change

=?Utf-8?B?SmFuZQ==?=
Guest
Posts: n/a

 27th Nov 2006
When i copied formulas from D1 through D6, why is it that D2 to D6 valve is
the same as D1? But the cell refects the correct formulas.

A B C D
1 122 455 577
2 528 45 577
3 3214 12 577
4 980 12444 577
5 154 87 577
6 31274 855 577

=?Utf-8?B?VGVldGhsZXNzIG1hbWE=?=
Guest
Posts: n/a

 27th Nov 2006
D1 =B1+C1
copy from D1 to D6

"Jane" wrote:

> When i copied formulas from D1 through D6, why is it that D2 to D6 valve is
> the same as D1? But the cell refects the correct formulas.
>
> A B C D
> 1 122 455 577
> 2 528 45 577
> 3 3214 12 577
> 4 980 12444 577
> 5 154 87 577
> 6 31274 855 577
>

=?Utf-8?B?TWF4?=
Guest
Posts: n/a

 27th Nov 2006
> When i copied formulas from D1 through D6,
> why is it that D2 to D6 value is the same as D1?

The calc mode may be inadvertently set to Manual. Press F9, does it now
compute properly? To check/change calc mode: Click Tools > Options >
Calculation tab. Options are there. Ensure "Automatic" is checked > OK.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jane" wrote:
> When i copied formulas from D1 through D6, why is it that D2 to D6 valve is
> the same as D1? But the cell refects the correct formulas.
>
> A B C D
> 1 122 455 577
> 2 528 45 577
> 3 3214 12 577
> 4 980 12444 577
> 5 154 87 577
> 6 31274 855 577
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Lanwench [MVP - Exchange] Windows XP General 11 3rd Mar 2008 09:35 PM David H. Lipman Windows XP General 0 2nd Mar 2008 11:20 PM =?Utf-8?B?cml5Y2hp?= Microsoft Access 1 10th Nov 2004 12:38 PM courtesio99 Microsoft Excel Programming 0 9th Jan 2004 08:03 AM Matt Johnson Microsoft Excel Charting 1 5th Dec 2003 06:01 PM

Features

Advertising

Newsgroups

All times are GMT +1. The time now is 08:52 AM.