"Formula too long" when changing linked sources??

G

Guest

I have a destination workbook linked to ten source workbooks. I want to move
them into other folders but when I do and try to edit the links I keep
getting a message that says "formula too long." Even just changing one source
doesn't work.
 
G

Guest

Did you figure this out? I have a similar problem? I am referencing the
same files but need to change source from old server files that aren't
accessible to new server files.
 
G

Guest

I did not figure it out. I ended up taking a longer route: essentially
building new folders. There is some kind of a formula auditor/evaluator under
"Tools" but I didn't use that so I don't know if that would be helpful. It
may help to get all the workbooks in the same folder and try changing the
source under "Edit", "Links".
Sorry I can't be of more help.

Fred
 

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

#N/A in linked cell 4
Linked Workbooks/Sheets 1
Excel Sumproduct Ref error when table is closed 0
Formula too long error 8
Link error #VALUE 5
Replacing part of a (too) long formula 5
linked formulas 1
How to create absolue path link to another workbook (Excel 2003) 1

Top