I have a spreadsheet with 25,000 rows and about 500 columns of data
Many of them have formulas in them, such that, when an entry is made in the column of "how many to order", ALL the formulas will be affected.
That causes about a 2 to 3 second delay before the user can enter the next value.
Is there a way to control it such that, for instance, only the corresponding row and column are affected. Or possibly only those that are visible
Any kind of help is appreciated
Many of them have formulas in them, such that, when an entry is made in the column of "how many to order", ALL the formulas will be affected.
That causes about a 2 to 3 second delay before the user can enter the next value.
Is there a way to control it such that, for instance, only the corresponding row and column are affected. Or possibly only those that are visible
Any kind of help is appreciated