ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linked cell truncating data (https://www.excelbanter.com/excel-discussion-misc-queries/242082-linked-cell-truncating-data.html)

officeuser

Linked cell truncating data
 
I have multiple individual status reports, and select cells from these is
linked to a summary report. It appears that data in the summary report is
being truncated at 255 when the status report cell is fine.

Dave Peterson

Linked cell truncating data
 
If the sending workbook is open in the same instance of excel as the receiving
workbook, then you'll see all the text.

If the sending workbook is not open in that same instance, you'll be limited to
those 255 characters.


officeuser wrote:

I have multiple individual status reports, and select cells from these is
linked to a summary report. It appears that data in the summary report is
being truncated at 255 when the status report cell is fine.


--

Dave Peterson


All times are GMT +1. The time now is 09:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com