Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2K - Formula too long msg

    I work in an environment where we build financial model sets that involve many workbooks. Some of my peers, since installing Office 2K, have been complaining that, when they build a formula that references several external workbooks which are open when the formula is being built, so only the workbook name and cell reference is showing, get a 'Formula too long' error message when reopening this workbook later when the linked workbooks are not open (now the fully qualified path is included with the workbook name)and they put the cursor in the formula bar. They seem to think that 255 characters seems to be the limit.

    I'm still using Office 97 and know I have lots of workbooks that contain these kinds of formulas that go well over 255 characters.

    Is there a difference or limit in Excel 9 that wasn't in Excel 8.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel 2K - Formula too long msg

    It isn't that the now full pathname is breaking the limit?
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2K - Formula too long msg

    Presumably... The people describing their problem to me are in a different location and I haven't been able to see this directly. I just did a short test on my own machine, and I have formulas, which I can edit with no trouble, that are over 1000 characters long when the full path names are displayed.

    Again, the only difference I can discern so far is that they're using O2K -- I've delayed my install of O2K pending completion of a project.

  4. #4
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2K - Formula too long msg

    <P ID="edit"><FONT SIZE=-1>Edited by GeneO on 01/03/21 23:03.</FONT></P>I did some testing and on my installation of Excel 8 SR-2, the limit seems to be 1024 characters in a Formula.

    Can anyone confirm if that's the case in Excel9?

    Post entry edit...
    (I found an answer in Q264626 which indicates 1024 is the limit in Excel 2000 also)

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Excel 2K - Formula too long msg

    I have experienced the same problem running Excel 97. Try opening all of the linked (or to be linked) files as you are building the formula. That should keep the full path out of the formula until you close the source files.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •