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:

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!

Any ideas?

Try copying the linked files to a short directory and use the linked files manager to update the links.

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!

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.

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

Can you post a sample .xls file (zipped) of this?

Here is the sample.

Also has a Macro to check the error.

Thanks!

Any ideas? Help?! HELP!?!?!

(I'm kind of desperate)