Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Formula too long" when changing linked sources??
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Formula too long" when changing linked sources??
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. "fred at pha" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Formula too long" when changing linked sources??
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 "BobbieB" wrote: 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. "fred at pha" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute value changing in linked workbooks | Links and Linking in Excel | |||
When linked objects update in Word,it keeps changing the spacing? | Excel Discussion (Misc queries) | |||
Changing font size of drop down box linked to cell | Excel Discussion (Misc queries) | |||
how do i record changing cell data (cell is dde linked) | Excel Discussion (Misc queries) | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) |