Excel struggles to respond with certain formula

Hwatsonnn

Board Regular
Joined
Nov 14, 2018
Messages
53
Office Version
365, 2019
Platform
Windows
I enter the number 45 into cell A1.

A2 formula: A1+1 (Returns "46")
A3 formula: A2+1 (Returns "47")
A4 formula: A3+1 (Returns "48")

I have this sequence for about 200 rows. I understand that you are able to just drag down to continue the sequence of consecutive numbers although this is in place to assist an inexperienced user and it works well.

Although recently making any adjustments in the A column will cause excel to become unresponsive for a period of time. Is it the PC's fault or is their an underlying problem with the formula which causes lots of calculations to take place. Thanks for any help :)
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Hwatsonnn

Board Regular
Joined
Nov 14, 2018
Messages
53
Office Version
365, 2019
Platform
Windows
I have now realised if there is text in A1, all of the below cells read "#VALUE". It is then when I insert a number into one of these cells I get the not responding error rather than a quick calculation of "+1" of the number I entered.
 

Watch MrExcel Video

Forum statistics

Threads
1,100,182
Messages
5,473,001
Members
406,843
Latest member
David_Welland

This Week's Hot Topics

Top