Overlapping data
If you inserted data into an area on the worksheet that previously contained CPM data, the previous data may not be properly cleared. In this case, the old formulas may still be present. Overlapping data can extend the formulas beyond the 255-character limit. When this happens, no data is shown on the worksheet.
To resolve this issue:
- Highlight the data area, and then select .
- Insert the data again.