| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
| if formula to check text and paste link | Excel Discussion (Misc queries) | |||
| link truncated | Links and Linking in Excel | |||
| Truncated text when copying text from one excel doc to another | Excel Discussion (Misc queries) | |||
| Copy and Paste from Excel to powerpoint the pix is Truncated | Excel Discussion (Misc queries) | |||
![Amol[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
