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?