2009 Q1 link clearance: Microsoft blogger edition


It’s that time again: Sending some link love to my colleagues.

Updates: Fixed name of product Microsoft Expression (no “s”). Also, I think Arvin’s blog is still up—it’s just being masked by a doppelganger. Will update as information becomes available.

Comments (10)
  1. Kevin says:

    In the interest of proper naming, it’s Microsoft Expression, not Expressions.  (I realize the mistake was made on the linked site, too).  The report of how easy it makes web design is completely correct, however.

    [Fixed, thanks. -Raymond]
  2. Jason says:

    I think you scared Arvin away: His blog page only contains a link back to itself that says "arvinwu" in large letters.

  3. James Schend says:

    I love Expression Web. If only it had the collapsable tags/JS functions that VS had, and the "autoformat" function, I’d never use VS again for HTML editing.

  4. DWalker59 says:

    Your link to Arvin Wu gives a page that just says "ArvinWu", and clicking on his name gives the same page that just says "ArvinWu".

    If he has a blog, what magic is required to see it?

  5. John says:

    I guess this is what happens when your posts are months out of date.  I was going to post a comment in one of the blogs until I noticed the entry was from August.  Arvin Wu probably died of old age by now.

  6. Neil (SM) says:

    My initial thoughts on the ICE was that Vista already included a panorama maker in the photo gallery (now Windows Live Photo Gallery.)

    But ICE looks like it has more options and features — a better product.

  7. Christian says:

    I love your sense of humour in the Kübler-Ross reference (5. stage is acceptance). Once I learned about it in religion classes (German schools have them) I succesfully applied it to many things, like learning for a test: It also starts with denial, then anger… and a few days before the test one finally accepts it and starts to learn/prepare :-)

  8. acq says:

    Arvin Wu probably died of old age by now, but Arvin’s entry is at the moment still in the cache:

    http://cc.msnscache.com/cache.aspx?d=75662139152504&w=ce50a5fb,a86f9583

    To preserve it since the cache can disappear fast:

    Some Excel 2007 limitation

    Here is a list of all of the major changes we made to Excel 12 in the area of limits.

    The total number of available columns in Excel

    Old Limit: 256  (2^8)

    New Limit: 16k  (2^14)

    The total number of available rows in Excel

    Old Limit: 64k  (2^16)

    New Limit: 1M  (2^20)

    Total amount of PC memory that Excel can use

    Old Limit: 1GB

    New Limit: Maximum allowed by Windows

    Number of unique colours allowed a single workbook

    Old Limit: 56 (indexed colour)

    New Limit: 4.3 billion (32-bit colour)

    Number of conditional format conditions on a cell

    Old Limit: 3 conditions

    New Limit: Limited by available memory

    Number of levels of sorting on a range or table

    Old Limit: 3

    New Limit: 64

    Number of items shown in the Auto-Filter dropdown

    Old Limit: 1,000

    New Limit: 10,000

    The total number of characters that can display in a cell

    Old Limit: 1k (when the text is formatted)

    New Limit: 32k or as many as will fit in the cell (regardless of formatting)

    The number of characters per cell that Excel can print

    Old Limit: 1k

    New Limit: 32k

    The total number of unique cell styles in a workbook (combinations of all cell formatting)

    Old Limit: 4000

    New Limit: 64k

    The maximum length of formulas (in characters)

    Old Limit: 1k characters

    New Limit: 8k characters

    The number of levels of nesting that Excel allows in formulas

    Old Limit: 7

    New Limit: 64

    Maximum number of arguments to a function

    Old Limit: 30

    New Limit: 255

    Maximum number of items found by “Find All”

    Old Limit: ~64k (65472)

    New Limit: ~2 Billion

    Number of rows allowed in a Pivot Table

    Old Limit: 64k

    New Limit: 1M

    Number of columns allowed in a Pivot Table

    Old Limit: 255

    New Limit: 16k

    Maximum number of unique items within a single Pivot Field

    Old Limit: 32k

    New Limit: 1M

    Length of the MDX name for a Pivot Table item; also the string length for a relational Pivot Table

    Old Limit: 255 characters

    New Limit: 32k

    The length at which fields’ labels are truncated when added to PivotTable; this also includes caption length limitations

    Old Limit: 255

    New Limit: 32k

    The number of fields (as seen in the field list) that a single PivotTable can have

    Old Limit: 255

    New Limit: 16k

    The number of cells that may depend on a single area before Excel must do full calculations instead of partial calculations (because it can no longer track the dependencies required to do partial calculations)

    Old Limit: 8k

    New Limit: Limited by available memory

    The number of different areas in a sheet that may have dependencies before Excel must do full calculations instead of partial calculations (because it can no longer track the dependencies required to do partial calculations)

    Old Limit: 64k

    New Limit: Limited by available memory

    The number of array formulas in a worksheet that can refer to another (given) worksheet

    Old Limit: 65k

    New Limit: Limited by available memory

    The number of categories that custom functions can be bucketed into

    Old Limit: 32

    New Limit: 255

    The number of characters that may be updated in a non-resident external workbook reference

    Old Limit: 255

    New Limit: 32k

    Number of rows of a column or columns that can be referred to in an array formula

    Old Limit: 65,335

    New Limit: Limitation removed (full-column references allowed)

    The number of characters that can be stored and displayed in a cell formatted as Text

    Old Limit: 255

    New Limit: 32k

    Posted Thursday, October 02, 2008 11:12 AM by Arvin Wu | 0 Comments

  9. Simon Cooke says:

    "Why doesn’t Office just fix all of the bugs before they ship it? "

    … the simple answer of course is "We’ve had these bugs since 1996, possibly earlier, and we’re quite fond of them at this point. Look at this one. It’s called Harold."

    (I’d just like one version of Word where doing ANYTHING with sections [and occasionally the equation editor in the new one] can cause corrupt documents that won’t save/load/print/edit correctly. It’s time to lift the ban on code changes in the core engine for Word, and get a crew in there to find the bugs).

  10. ::Wendy:: says:

    Oh!  colleagues in the sense that we are mutual appreciators of bus technology,  and I don’t mean PCI Express,  more National Express (UK)…

Comments are closed.