| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error messages
Thanks. I'll start out working with the 1024 length.
"Farhad" wrote: I think the limitation is 1024 characters well you need to make short the file names and folder names. or see if your can go other way and make your formula shorter. Thanks -- Farhad Hodjat "DAE" wrote: I could do that but the workbook is complex enough already. The formulas are long due to long pathnames in references, not due to complex operations, and they work error-free as is. But I need to change the pathnames. Do you know if there is a limit on number of characters or something else that is specific to search & replace? "Farhad" wrote: I need to see your formula and see if i can shrink it but the final sugestion would be to split your formula in 2 cells i mean do half of your formula in one cell and do the rest in another cell. Thanks -- Farhad Hodjat "DAE" wrote: How can I fix a "Formula is too long" error that occurs during search & replace operations? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Name error messages... | Excel Worksheet Functions | |||
| Error Messages | Excel Discussion (Misc queries) | |||
| error messages | Excel Discussion (Misc queries) | |||
| Error Messages | Excel Worksheet Functions | |||
| Error Messages | Excel Worksheet Functions | |||
Hybrid Mode
