You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Tips
How-to
News
Videos
Stories
When we started Excel 2007, we made a decision that as part of increasing the grid size, we were going to address a lot of important other “limits” in the product. The entire list can be seen here, in the second post I ever made to this blog. (Note, this is probably a good place to note that we had to back out the change to “The number of characters that can be stored and displayed in a cell formatted as Text” recently – we found a problem with the implementation that couldn’t be fixed at this late date, so we are going to address it next time.)
When we developed the list of limits to address, we approached the research a few different ways. We tried to identify anything that would prevent users from using the “big grid” to its fullest. We tried to address top customer requests, whether they came from our support team, the newsgroups, web searches, and the like. We talked to our large enterprise customers and developers. We went through old support records. Etc. Having done that, and made a lot of changes in Excel 2007, we have already started to identify candidates for the next version – for example, the number of discontinuous ranges that can be selected, the number of categories shown in the function dialog, etc.
What else would you like to see us work on in this area? Are there any limits that you run into frequently that you think we should try and increase or eliminate in the next version of Excel?
Comments: (24) Collapse
So, do I understand right that max no. of points in a chart series is still 32K? It would be very disappointing.
Howdy folks,
Thanks for the ideas and feedback, as always. Glad to hear we are already hearing requests for more rows :-).
If others out there have multiple monitors and have other ideas of how we could do better there, please share.
The number of points in a chart series has not changed this release, no. On the list for the future. Beyond scatter plots, what sorts of charts are people building that show huge numbers of points?
Selecting discontinuous cells is another one that we are well aware of, but which will not change in 2007.
Dan, the comments thing is not a bug, but an internal limit.
TechieBird, I am optimistic that some of the internal work we did this time will help in this regard, but I am always happy to look at workbooks that have problem, so feel free to contact me.
Tianwei, the limit has been increased to 1 million.
Re: "Beyond scatter plots, what sorts of charts are people building that show huge numbers of points?"
Well, line and area charts occasionally provide interesting insight with massive # of points. Mainly scatter, though.
Sorry, previous post on charting should be attributed to "Kizzer"
What is the backward compatibilty for grid size? If I have >64k rows and client has older version can they open it? I do not have a 2007 beta to check the compat.
Thanks
Matt - please see blogs.msdn.com/.../694606.aspx
The Data Table command has a 2 Input Variables + 1 Solution limit
Extend the input and solutions to several variables and dump the data in a table of columns of input variables and solutions
Then the table can be used by Pivot tables/graphs etc for analysis
I have a working model at www.ianeva.info/.../4D_Data_Table.html
Ian Huitson
Increase the number of outline levels please (currently only 8, same as the previous version).
Conditional Oulines without a UDF
Now theres a good idea.
***...