How do I get around Excel formula is too long error message?

G

Guest

I am in the process of creating multiple links to multiple wookbooks (within
one cell) and keep running into the problem that the formula will start
giving me the error message that the formula is too long. Is there a way
that I could disable this feature, thus allowing me to expand the formula to
include additional links to additional workbooks.

Please advise.

Thanks
 
F

Frank Kabel

Hi
post yoiur existing formula. This is not a feature but a fixed
restriction (no way around it). Some common solutions
- split your formula
- use defined names
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula too long error 8
Formula too long 3
Formula to long error 2
"Formula too long" when changing linked sources?? 2
formula too long error 2
Formula Too Long Errors 1
Formula too long 2
Replace html code - formula too long 1

Top