Linked worksheets

G

Guest

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?
 
D

Dave Peterson

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting in multiple worksheets 1
Linked cells between worksheets and sorting 2
Cells act as if they are linked-link does not display in entry bar 1
Linking worksheets, rearranging rows. 1
Linked Cells 3
Sorting non-linked cells in a linked worksheet 1
Stop linked cells from changing when insert new row? 1
Paste Values in linked Cells Only 4

Top