Ever since the Update for Microsoft Excel 2007 KB973593 (Microsoft install update 11/11/09) installed on several users machines here, old .xls spreadsheets (created as MS Excel 97-2003 workbooks a year or two ago) with macros have an Excel rendering issue with cells breaking apart and/or disappearing.
All of our company users have Office 2007 on their machines. It doesn't seem to matter what type of machine they have; some have Dell pcs, others have HP pcs, so a specific hardware issue isn't the culprit.
I can't save the .xls spreadsheets as .xlsx because I get an err message stating that "The following features cannot be saved in macro free workbooks: VB Project. To save a file with these features, click No, then choose a macro enabled file type in the File Type list. To continue saving as a macro free workbook, click Yes".
I can save as an .xlsm but the users here prefer to save it as an .xls or .xlsx if they can.
As a test, I removed Security Update for Microsoft Excel 2007 KB973593 from my pc. I no longer have the Excel rendering/cells breaking apart/disappearing issue. But I can't not have this update on users' pcs here, the patches are there for a reason, and it wouldn't be ideal to leave the pcs unpatched for that long.
Has anyone else seen this issue?