Excel 2007 sheet copy: Application-defined or object-defined error

excel-2007-application-or-object-defined-error.png

When you use the code sheet.copy normally a new workbook is created with a copy of that particular sheet. However in Excel 2007 (SP1) if the original workbook contains a macro when you run the code the first time you (might) get the following error: I could only reproduce this error when the original workbook […]

Office 2007 Service Pack 1 coming on December 11th

Check for Microsoft Updates

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 […]

Problem with copying filtered data in Excel 2007 + workaround

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 works. You can […]

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

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, […]

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

Excel 2007 with ASAP Utilities in the 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 […]

Preview ASAP Utilities ribbon for Excel 2007

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 […]

Fix the slow startup of Excel 2007

Excel 2007 Splash Screen

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 […]

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

Excel options

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 […]

Excel 12 : "save as PDF"

Office 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 […]

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.

Official Excel 12 blog: more rows and columns in Excel 12

Today David Gainer, Group Program Manager for Microsoft Excel has started an official Excel blog. Until the public release of Excel 12 (medio 2006 probably) he will publish about new stuff in Excel 12. Well the first news he posts is great, more rows and columns! (like Quattro Pro has for years). From his site: […]