Change source on links error

K

Kathy

I have a user who has an unbelievable amount of
characters in some of her formulas. The problem is now
she wants to use change source on links, but she receives
the error "Formula is too long" She can't even do a find
and replace on the directory name, she receives the same
error. Is there any way around this?
 
F

Frank Kabel

Hi
if shee exceed 1024 characters no easy way. You may try to use defined
names or change the formula. You may post one of these formulas 8maybe
they can be shortened)
 

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

YEAR function name not found 6
Look-up 3
EDate function + #NAME? error 10
Change of name 3
Outlook 2002 E-Mail Signatures 2
#NAME? Error 3
OT? Chromebook 8
Some people have no sense 1

Top