I have a single cell in 34 worksheets linked to another worksheet. The data
in the linked cells is text. In the worksheet that the cells are linked to
only some of the data is shown until the linked worksheet is opened, why?
After openning the worksheets all data is shown until the linked sheet is
closed and excel is closed then the data is incomplete again eventhough the
complete file was saved, WHY?

Excel brings a maximum of 255 characters back from a closed workbook.

It'll bring back the complete string when the workbook is open.



John Kelly wrote:

I have a single cell in 34 worksheets linked to another worksheet. The data
in the linked cells is text. In the worksheet that the cells are linked to
only some of the data is shown until the linked worksheet is opened, why?
After openning the worksheets all data is shown until the linked sheet is
closed and excel is closed then the data is incomplete again eventhough the
complete file was saved, WHY?

--

Dave Peterson