Issue with automatic increment in EXCEL Solved

Question

Hello,

I have a problem with a table in EXCEL 2003.

I have a column where I want to automatically sum the previous values. To create a cumulative total.

I was given the steps to follow before and I used to do it well, but now it doesn't work anymore.

Specifically:

I have a column E with values, E1=1, E2=2 ...
A column G where I want to see G1=E1, G2=G1+E2, G3=G2+E3

Before, I would enter the formula in the first cell and the second, then I would drag the little cross in the bottom right corner, and the formula would adapt and automatically give me my cumulative total.
Now, it doesn't. If I have 10 in E3 and I drag it, it shows the same thing everywhere.
Even though the cell contents adapt the formula.

I've been racking my brain, and I can't quite figure out why this is happening...

Thank you in advance for the time you are willing to dedicate to me.

Configuration: Windows XP Firefox 2.0.0.16

qwerty · Accepted Answer

go to tools => options => calculation and check that you are on "automatic" and not on manual

CaPiT · Answer

Hello,  if it doesn't work when you drag it, copy the formula, then select all the cells you want and paste it. A small suitcase will appear and you select "Keep source formatting."

Raymond PENTIER · Answer

No, you are mistaken: Your incremental copy should be based on E2 and E3, which contain the same formula, and not on E1 and E2, which contain different formulas.
Verification: In G3 you have =E3, in G5 you have =E5, while the formulas are correct in G4, G6, G8 ...
--
It's nice, retirement! Especially in the Caribbean ... :-)
Raymond

qwerty · Answer

manual, not mauel... sorry

emelianenko_fedor · Answer

EDIT: Oops, I didn't see the other responses while I was writing mine. I only had one at that moment. I'll try the other options. Thanks!

Hello and thank you for your response.

When I do it like this, it also copies the same starting value into G2. And on the small suitcase, it is already set to keep the source formatting.
It's really strange because, as before, it correctly copies the right formulas into the destination cells, but the result remains that same initial number.
I've compared it with the last table I created the same way; the cells are written the same way, yet the result adapts well to the formulas :/

There must be something that I missed, but I don't know what...

emelianenko_fedor · Answer

Good evening Raymond.
Actually, I had only done the increment from cell E2 (after taking E1 and E2 into account)
It was the same. But Qwerty is right, the problem came from the calculation options.
I don’t even know why that changed, I had never touched that.

It was indeed set to manual. When I switched it to automatic, miracle, the drag worked immediately and the total was correct.

So my problem is solved.
Thanks again to everyone for your help and advice! :D

Monique · Answer

If the increment (automation of calculations) is no longer functioning, go to: tools, options, calculation and reactivate the ''automatic'' box.

Issue with automatic increment in EXCEL

7 answers

Texture issues in enshrouded

I can’t access my usb drive

Ricoh sp c262dnw

Usb adapter?

No sender name when sending an email

Windows 11 stuck in pin setup loop

Compare numbers from two arrays.

Block itunesrestrict access to itunes?

Outlook deleted mail recovery

Falsifying odometer readings even fools the technical inspections.