Office 2007 Service Pack 1 coming on December 11th

For your information, next Tuesday the first Service Pack for Office 2007 will be released.
Service Pack 1 for the 2007 Microsoft Office system will be available for download on December 11th. We will be sharing more details at that time, but the improvements are focused on stability, performance and security.
I'm very curious if the [...]

Problem with copying filtered data in Excel 2007 + workaround

Filter' align='right' style='margin-left:10px;'/>I just got an email that says you cannot copy only the filtered data in Excel 2007. If you use the autofilter to make a selection and then you only want to copy the filtered rows, Excel 2007 copied everything, even the hidden rows. This is different from the way Excel 2000-2003 [...]

Protect sheets: The EnableSelection property is not saved + Excel update fix

Yesterday I got the following question: "When using the “protect multiple sheets at once” and checking only the “select unlocked cells” checkbox I find that once I save and reopen the sheets now behave as if both the “select unlocked cells” as well as the “select locked cells” seems to be in effect as I [...]

Fixed the statup delay in Windows XP + Excel 2007 when opening a file through the Windows Explorer

The latest version of ASAP Utilities (pre-released today) will solve an issue that can appear when you have both Windows XP and Excel 2007 installed.
"After installing the latest version of ASAP-Utilities after upgrading to Office 2007, I began to encounter a problem with Excel 2007 where, upon clicking on an Excel file to open, the [...]

Pre-release ASAP Utilities version 4.1.3 RC3 (Excel 2007 ribbon)

I have just published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing.
The major change in this version is in combination with Excel 2007 where ASAP Utilities now has its own tab in the ribbon.
Preview with the blue (Excel default) theme:

Preview with the black theme:

A screenshot of [...]

Preview ASAP Utilities ribbon for Excel 2007

I am currently working on an Excel 2007 ribbon-menu for the new ASAP Utilities.
Right now the ASAP Utilities menu is visible in the Add-ins tab but the new version will have its menu integrated in the ribbon.
Preview of the new ASAP Utilities menu
A preview of the new ASAP Utilities ribbon in Excel 2007:
More information and [...]

Fix the slow startup of Excel 2007

Recently I have been receiving a few emails about people telling me that their Excel 2007 would startup very slowly with ASAP Utilities installed. The delay also occurred without ASAP Utilities if they click on an Excel file from within the Explorer:
If I click on an xls file Excel opens with a blank window which delays…
If [...]

Excel 2007: Show the Developer tab or run in developer mode

When you install the new Office 2007 the first thing you want to do is show the developer tab.
You should display the Developer tab or run in developer mode when you want to write macros, run macros that you previously recorded, or create applications to use with Microsoft Office programs.

Click the Microsoft Office Button Button [...]

Excel 12 : “save as PDF”

Excel and some other Office 12 applications will have a "save as PDF" function. This was posted yesterday by Dick Kusleika (Daily Dose of Excel) and Chris Pratley (Chris_Pratley's OneNote WebLog) who both joined the 2005 MVP Summit.
A quote from Cris' website:
Today was a fun day. It was our last day with our MVPs visiting [...]

Some other numbers on Excel 12

Last monday David Gainer from Microsoft has posted more details on Excel 12 on his weblog. Much of the new expanded limits have to do with the new grid.
http://blogs.msdn.com/excel/archive/2005/09/26/474258.aspx
Personally I really like the new grid. More rows and more columns allow you to import more data for analysis.