Character limitations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a spreadsheet that is intended as a database, from with other
spreadsheets will pull information via "lookup" functions. However, these
other spreadsheets cut off some of the information contained in lengthy
cells. These lengthy cells are well below the 1,024 character limit, though.
Any thoughts as to a fix?
 
Are you retrieving data from other workbooks (I'm not sure what a spreadsheet
is)?

Are those other workbooks closed?

If the "sending" workbook is open, then I bet you see all the text.

If the "sending" workbook is closed, then I bet you see about 255 characters
(after a recalc).

That's the way excel works.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Cell limit of characters 4
Chracter Limit Help!! 7
How do I get more than 255 characters into a cell? 3
Number of characters in a cell 3
Merged cell text does not wrap 1
Data missing when pasting from Access into Excel 3
Update links not updating correctly 3

Back
Top