Excel Unable to process the request.

Asked By angelandris 0 points N/A Posted on - 09/03/2011

I opened Excel sheet and tried to perform any operation then I received the error below.

I am trying to add some numbers and list of numbers are in hundreds.

I can’t do it manually. So please tell me why this error appears and how can I remove this error.

Error:

Excel

Unable to process the request.     

Wait a few minutes and try performing this operation again.

• Status: Open
• Question Views: 1814
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Martha Flixs

Go To Solution

Best Answer

Best Answer

Answered By Martha Flixs 0 points N/A #121002

Excel Unable to process the request.

That error appeared because you performed an illegal function.

Here is the solution on how to put values on every cell in a column without doing it manually.

Automatically put values 1-10 in column A row 2 to row 11:

In column A row 3, type =SUM(A2+1), as shown below:

Click on column A row 3 then press CTRL + C

Move cursor to row 4 then drag it down to row 11 by pressing SHIFT + ARROW DOWN then hit ENTER.

The result will be like this:

Now, enter the value 1 in column A row 2 then hit ENTER.

The succeeding cells after row 2 will automatically change its values after hitting ENTER.

This is the solution if you need to input extremely numerous values.

About Martha Flixs

Questions
0

Answers
9

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 09/03/2011
• Question Category: MS Excel

Answered By Emily Schultz 0 points N/A #121004

Excel Unable to process the request.

Excel sheets need accurate numbers and formulas to perform its duties. Just like numbering, counting, adding and to name a few.

What you want is to do counting from 1 up to 10 all the way down, right?

Best thing to do is to drag the first cell after highlighted, then a tiny black square will be shown. See screenshot for full understanding what I meant.

Then drag all the way to the bottom up, it auto-counts the numbers according to the area where you've stopped.

Easy enough and not so complicated. It makes your life easier without formulas and confusing a+b+c to add it all up.

About Emily Schultz

Questions
0

Answers
20

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 09/04/2011
• Question Category: MS Excel