{"id":1369,"date":"2012-12-05T23:03:37","date_gmt":"2012-12-05T22:03:37","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=1369"},"modified":"2021-11-11T17:46:13","modified_gmt":"2021-11-11T16:46:13","slug":"limity-specifikace-excel","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/limity-specifikace-excel\/","title":{"rendered":"Excel 2003 and 2010 limits and specifications"},"content":{"rendered":"

<\/p>\n

Are you interested in the limits of Excel and its\u00a0comparison to the older and the new version? Then, just for you I have prepared a table of selected specifications and comparisons between versions 2003 and 2010. At the end of the table are cross-referenced to the complete official specs from the Microsoft website.\u00a0If this guide has helped you, become a fan on Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n

Limits and specifications Excel<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Description<\/strong><\/td>\nExcel\u00a02003<\/strong><\/td>\nExcel 2010<\/strong><\/td>\n<\/tr>\n
Number of cells in a sheet<\/strong><\/td>\n65 536 rows and\u00a0256\u00a0columns<\/td>\n1 048 576 rows\u00a0and 16 384\u00a0columns<\/td>\n<\/tr>\n
Max. length of a cells content<\/strong><\/td>\n32 767\u00a0chars<\/td>\n32 767\u00a0chars<\/td>\n<\/tr>\n
Limit of sheets in a workbook<\/strong><\/td>\nlimited by PC memory<\/td>\nlimited by PC memory<\/td>\n<\/tr>\n
Decimal places\u00a0accuracy<\/strong><\/td>\n15\u00a0digits<\/td>\n15\u00a0digits<\/td>\n<\/tr>\n
Formula length<\/strong><\/td>\n1 024 chars<\/td>\n16 384 chars<\/td>\n<\/tr>\n
Function arguments limit<\/strong><\/td>\n30<\/td>\n255<\/td>\n<\/tr>\n
Merged functions in a formula<\/strong><\/td>\n7<\/td>\n64<\/td>\n<\/tr>\n
Go back steps<\/strong><\/td>\n16<\/td>\n100<\/td>\n<\/tr>\n
Dates range<\/strong><\/td>\n1.1.1900 – 31.12.9999<\/td>\n1.1.1900 – 31.12.9999<\/td>\n<\/tr>\n
Number of PivotTable on the sheet<\/b><\/td>\nlimited by PC memory<\/td>\nlimited by PC memory<\/td>\n<\/tr>\n
Row or Column fields in PivotTables<\/strong><\/td>\nlimited by PC memory<\/td>\nlimited by PC memory<\/td>\n<\/tr>\n
ReportFilter page fields in PivotTables<\/strong><\/td>\n256<\/td>\n256<\/td>\n<\/tr>\n
Data fields in PivotTables<\/strong><\/td>\n256<\/td>\n256<\/td>\n<\/tr>\n
Changing cells in scenarios<\/strong><\/td>\n32<\/td>\n32<\/td>\n<\/tr>\n
Unique values in PivotTable<\/strong><\/td>\n32 500<\/td>\n1 048 576<\/td>\n<\/tr>\n
Scenario limit<\/strong><\/td>\nlimited by PC memory<\/td>\nlimited by PC memory<\/td>\n<\/tr>\n
Complete specs link<\/strong><\/td>\nExcel 2003 specs<\/a><\/td>\nExcel 2010 specs<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Are you interested in the limits of Excel and its\u00a0comparison to the older and the new version? Then, just for you I have prepared a table of selected specifications and comparisons between versions 2003 and 2010. At the end of the table are cross-referenced to the complete official specs from the Microsoft website.\u00a0If this guide […]<\/p>\n","protected":false},"author":1,"featured_media":413,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3],"tags":[10,58],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/1369"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=1369"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/1369\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/413"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=1369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=1369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=1369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}