Formula too long - new file path is shorter than old file path - Excel 2003
 

Our network drive has been upgraded and now the full path to linked
workbooks in our master workbook are much shorter (less than half the
length) than they used to be. When we are prompted to update some of
the links to workbooks, we are getting the message "formula too long"
and it appears to be relating directly to the formula's containing the
linked document paths.

Formula too long - new file path is shorter than old file path - E
 

I am having this EXACT same problem and no matter what I do I can not get my
full path to show in the formula. The worksheet I'm working on was built
several years ago, and was originally in lotus. (I inherited it from someone
who retired) Do you have similar circumstances? I'm wondering if the new
way filepaths are written is new to an upgraded version of Excel?

"Greg J" wrote:

Our network drive has been upgraded and now the full path to linked
workbooks in our master workbook are much shorter (less than half the
length) than they used to be. When we are prompted to update some of
the links to workbooks, we are getting the message "formula too long"
and it appears to be relating directly to the formula's containing the
linked document paths.