Articles, interviews and news regarding Microsoft® Office products and data recovery. With a growing list of over 20 authors, the Expert Zone is your one stop resource center for Office tips and tricks as well as in depth articles.
ExcelFIX 5.39 released June 25th, 2008
2008-06-25
Includes improvements and changes in the Excel recovery program, ExcelFIX.
ExcelFIX 5.38 released April 25th, 2008
2008-04-25
Includes improvements in the Excel recovery engine, ExcelFIX.
ExcelFIX 5.37 released April 22nd, 2008
2008-04-22
Includes improvements and changes in the Excel repair tool, ExcelFIX.
Microsoft Warns of a New Excel Vulnerability | Expert Zone
2008-01-17
This past Tuesday Microsoft informed that there is a flaw that affects Excel for both Mac and Windows systems, that allows a hacker to booby-trap an Excel file.
Creating basic data reports with ListObjects and QueryTables | Expert Zone
2008-01-09
In this article we will take a closer look on how we can create a basic data report with VBA for Excel 2003 and 2007. With a basic report I refer to solutions where data is, for instance, retrieved from a central database, which is then placed in a worksheet.
Chart Copying Macro in Excel | Expert Zone
2007-10-29
This Excel 2003 macro code copies charts that exist on individual sheets onto one sheet, sizes them, and previews for printing. It then blanks out the sheet used for consolidation so it is ready for the next time. It works quite well for consolidating multiple charts onto one sheet for printing purposes.