Text Truncated after Paste link in Excel 2002
 

Hi,
I have a excel file, which reads from many other excel files (created
and updated by other users). I use Paste Links to read the data I need
from the source files but due to 255 character limit the text string
gets truncated after 255 characters. Does anyone know a workaround or
solution for this? Please let me know. I am still using Excel 2002.
Thanks in advance.
Regards,
Amol

Text Truncated after Paste link in Excel 2002
 

That's the way excel works when the "sending" workbook is closed.

You can open the workbook and recalc, but if you close that sending workbook,
you'll see the problem again.

Amol wrote:

Hi,
I have a excel file, which reads from many other excel files (created
and updated by other users). I use Paste Links to read the data I need
from the source files but due to 255 character limit the text string
gets truncated after 255 characters. Does anyone know a workaround or
solution for this? Please let me know. I am still using Excel 2002.
Thanks in advance.
Regards,
Amol

--

Dave Peterson

Text Truncated after Paste link in Excel 2002
 

On Jun 20, 8:40 pm, Dave Peterson wrote:
That's the way excel works when the "sending" workbook is closed.

You can open the workbook and recalc, but if you close that sending workbook,
you'll see the problem again.

Amol wrote:

Hi,
I have a excel file, which reads from many other excel files (created
and updated by other users). I use Paste Links to read the data I need
from the source files but due to 255 character limit the text string
gets truncated after 255 characters. Does anyone know a workaround or
solution for this? Please let me know. I am still using Excel 2002.
Thanks in advance.
Regards,
Amol

--

Dave Peterson

Hi Dave,
Thanks for your email. I know when the source file is also open then
it will read the entire text but the problem is I have 40-45 source
files and its cumbersome to open so many files to view the complete
text string. Is there any other way to do this? Please let me know.
Regards,
Amol

Text Truncated after Paste link in Excel 2002
 

Not that I know.

Amol wrote:

On Jun 20, 8:40 pm, Dave Peterson wrote:
That's the way excel works when the "sending" workbook is closed.

You can open the workbook and recalc, but if you close that sending workbook,
you'll see the problem again.

Amol wrote:

Hi,
I have a excel file, which reads from many other excel files (created
and updated by other users). I use Paste Links to read the data I need
from the source files but due to 255 character limit the text string
gets truncated after 255 characters. Does anyone know a workaround or
solution for this? Please let me know. I am still using Excel 2002.
Thanks in advance.
Regards,
Amol

--

Dave Peterson

Hi Dave,
Thanks for your email. I know when the source file is also open then
it will read the entire text but the problem is I have 40-45 source
files and its cumbersome to open so many files to view the complete
text string. Is there any other way to do this? Please let me know.
Regards,
Amol

--

Dave Peterson