Results 1 to 9 of 9
  1. #1
    Join Date
    Apr 2008
    Posts
    189

    Question Unanswered: Cell formula longer than 255 chars: error!

    Hello,
    I have a cell in an Excel 2003 sheet, that has a simple "=SUM(" formula.
    This formula is related to some linked files, so the formula is longer than 255 chars, like:

    Code:
    =SUM(//Server1/Path1/Path2/Path3/Blah_Blah_Blah/File1.xls!A1;//Server1/Path1/Path2/Path3/Blah_Blah_Blah/File1.xls!A1;//Server1/Path1/Path2/Path3/Blah_Blah_Blah/File1.xls!A1;//Server1/Path1/Path2/Path3/Blah_Blah_Blah/File1.xls!A1;//Server1/Path1/Path2/Path3/Blah_Blah_Blah/File1.xls!A1;//Server1/Path1/Path2/Path3/Blah_Blah_Blah/File1.xls!A1...)
    And so on... It's so long that has more than 1000 chars on the formula definition.

    The thing is when I try via VBA code to "show" or know the "LEN(" of this formula says:

    (see attachment)

    Any ideas how to solve this?
    I mean, I need to "catch" that error... and "On Error GoTo XXXX" doesn't work.

    Thanks!
    Attached Thumbnails Attached Thumbnails Dibujo.JPG  

  2. #2
    Join Date
    Apr 2008
    Posts
    189
    Any ideas?

  3. #3
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    Try copying the linked files to a short directory and use the linked files manager to update the links.

  4. #4
    Join Date
    Apr 2008
    Posts
    189
    Yeah, but not a solution:
    I don't have the source files.

    Also, I want to save the original file path.

    Thanks, but still no solution to this issue!


  5. #5
    Join Date
    Oct 2003
    Posts
    1,091
    Can you pull in individual pieces onto one worksheet, then setup the SUM formula on another worksheet, so you reference only that worksheet?

    i.e. on worksheet Sheet1, in cell A1 you would put

    //Server1/Path1/Path2/Path3/Blah_Blah_Blah/File1.xls!A1

    in B1 you would put

    //Server1/Path1/Path2/Path3/Blah_Blah_Blah/File1.xls!B1

    etc. Then on worksheet Sheet2

    =SUM(Sheet1!A1,Sheet1!B1.... etc.
    Last edited by shades; 10-31-08 at 15:23.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  6. #6
    Join Date
    Apr 2008
    Posts
    189
    I have the file that I want to copy: already done.
    I don't want to change it.

    I just need to copy what is on the cells. The formula property.

    I don't see the light here

  7. #7
    Join Date
    Oct 2003
    Posts
    1,091
    Can you post a sample .xls file (zipped) of this?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  8. #8
    Join Date
    Apr 2008
    Posts
    189

    Arrow

    Here is the sample.

    Also has a Macro to check the error.

    Thanks!
    Attached Files Attached Files

  9. #9
    Join Date
    Apr 2008
    Posts
    189
    Any ideas? Help?! HELP!?!?!

    (I'm kind of desperate)

Posting Permissions

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