Microsoft Excel Formula is too long.

Asked By johnhegry 1180 points N/A Posted on - 08/03/2011

My greetings to all techyv readers,

I have a problem here to consult. Every time I input a long formula in Microsoft Excel, I meet an error message that the formula is to long.

Microsoft Excel

Formula is too long.

As I read on the error message, I am having a problem on how to finish my report since I really need to use the long formula that will make my work easier. If I will not use the long formula my work will take many hours by doing some manual computations.

Please share some ideas on how to let Microsoft Excel accept long formula.

Thanks a lot.

• Status: Open
• Question Views: 3189
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by imtiaz

Go To Solution

Answered By LisaPhillips525 0 points N/A #122309

Microsoft Excel Formula is too long.

Hi,

Hope you are using MS Office 2007, then a cell can carry 8,192 characters in a formula. If your formula is longer than that bit is good to enter a half of the formula in one cell and get the answer and combine with the formula in another cell.

If you want to get the answer for part of the formula you can press ‘F9’ while the cell is selected.

Or you can try to reduce the number of unnecessary characters entered in the formula by renaming some worksheets referred in the formula. As an example, sheet1 can be renamed as S1.

About LisaPhillips525

Questions
0

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

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

Best Answer

Best Answer

Answered By imtiaz 0 points N/A #122307

Microsoft Excel Formula is too long.

Mr. Johnhegry.

Text contents up to 30,000 or more characters long. Your text formula use in 1 half method.

You can increase your space to save. Windows must be relevant on MS Excel version. It will be effect on speed of PC. Here you can go from some logic:

1. Take your available space how enough depends on you.

2. If the text up to 5000 or more background somewhere it might accept and you will perform the best event.

Don't think about your variation and violate just use all system what you used in before formula and surely increase your text long.

Then you may get your happy terms.

Thanks.

About imtiaz

Questions
0

Answers
9

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 08/13/2011
• Question Category: MS Excel

Answered By Sherri J Smith 10 points N/A #122311

Microsoft Excel Formula is too long.

Hi Johnhegry

Side by side aforementioned  solutions also check this Techyv post. This post IS also addressed your problem. 

How can Excel accept very long formula?

About Sherri J Smith

Questions
5

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/08/2014
• Question Category: MS Excel