SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Windows Vista

Is there a limit to the cell size in Excel

(2 posts)
  • Started 6 years ago by Tan
  • Latest reply from nrv1013
  • Topic Viewed 15169 times

Tan
Posts: 1

I have a database report which I am exporting into a spreadsheet, but for some reason it cuts off some of the text when exported to excel. Is there a limit to a cell size in Excel? Any ideas of how I can export all data from the report into a spreadsheet.

Posted 6 years ago
Top
 
nrv1013
Posts: 35

Excel 2003 limits:
http://office.microsoft.com/en.....11033.aspx

Excel 2007 limits:
http://office.microsoft.com/en.....etWorkbook

Both limit the length of cell contents to 32,767 characters, but in 2003 only 1,024 display in the actual cell.

Posted 6 years ago
Top
 



Topic Closed

This topic has been closed to new replies.

Enter Your Email Here to Get Access for Free:

Go check your email!