Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel file with hyperlinks takes a long time to open over the network Didier P Links and Linking in Excel 3 July 4th 06 04:39 PM
Insert & link a graphic file in Excel 2003 -- updatable pictures! ODI Excel Discussion (Misc queries) 7 November 14th 05 03:36 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
EDIT FORMULA BAR in excel 2003? why not? where is it? alnav89 Excel Worksheet Functions 2 April 26th 05 07:02 PM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 14th 04 12:51 AM


All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"