My company just upgraded to Office 2007. Here are my thoughts/nitpicks:
1. Completely new user interface that looks much like Vista
2. All the classic style menus and commands are no longer there, need to struggle with the online help just to perform the same command in Excel 2003 or earlier. Steep learning curve for those accustomed to the classic Excel interface.
3. Excel 2007 always opens earlier versions in compatibility mode. It keeps warning me of significant functionalities lost as a result. Any idea how to disable that?
4. Apparently, Excel 2007 is able to handle more than 65,536 rows by 256 columns.
5. My VB scripts created in earlier versions appear to run into some problems in the new version. Tried troubleshooting but nothing appears to be wrong.
6. Files saved on Excel 2007 appears to be much larger size than the older versions, even after using the KillRows and ExcelDiet function.
7. When I select Autofilter to some criteria and tried to copy the filtered values to another worksheet, Excel 2007 copies the entire chunk of data over to another worksheet. This was not observed in previous versions. What has gone wrong here?
In view of so many problems, I would have each and every intention go get my IT dept to fallback to earlier versions.
Any comments/workarounds would be most appreciated.