If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Text Truncated after Paste link in Excel 2002
1. Open Excel
2. Open the source file(s) in that instance of Excel with File Open ...... 3. Open the destination file in the SAME instance of Excel with File Open.... Excel will then NOT prompt you with "do you want to refresh links..." Excel will refresh the links correctly automatically -- Gary''s Student - gsnu200733 "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 |
Thread Tools | |
Display Modes | |
|
|