Wednesday, July 27, 2011

How to Fix Excel 2007


1. Double-click the Excel 2007 program icon on your desktop to open it or select its name from the list of programs in the Start menu's 'All Programs' list. Click the Excel Office button and select 'Excel Options.' Click 'Advanced' and scroll down to the 'General' section. Click the checkbox to remove the checkmark from 'Ignore other applications that use Dynamic Data Exchange (DDE).' Close Microsoft Excel. Double-click on any saved Excel file to open it and see that the 'There Was a Problem Sending the Command to the Program' error message no longer appears.
2. Open the Excel program. Click the Office button and select 'Excel Options.' Click 'Advanced' and scroll down to the 'Display options for this workbook' section.' Click the 'All' radio button under 'For objects, show' to get rid of the 'Cannot shift objects off sheet' error message when you try to insert or hide rows or columns. Click 'OK.'
3. Open Windows Explorer. Double-click the 'C:' drive to expand its directory. Double-click 'Program Files' or 'Program Files (x86).' Expand the 'Microsoft Office' directory. Expand either the 'Office,' 'Office10' or 'Office12' folders. Double-click the 'Startup' folder to open it. Right-click on 'pdfmaker.dot' and click 'Cut.' Navigate to your 'My Documents' folder. Right-click the folder and select 'Paste.'Repeat the process to remove the 'pdfmaker.xla' file from the 'Xlstart' folder---located in the 'Office' folder under the 'Microsoft Office' directory---and place it into the 'My Documents' folder. Moving these Adobe Acrobat files gets rid of the 'Compile error in hidden module: Autoexec' and 'DistMon' error messages when opening Excel 2007.
4. Open the Control Panel. Go to the 'Add or Remove Programs' section in Windows XP and the 'Uninstall a Program' section in Vista and Windows 7. Click Microsoft Excel or Microsoft Office from the list of programs. Click 'Change.' Select 'Repair' and click 'Continue' to run the 'Detect and Repair' tool to automatically have Microsoft find and repair problems with your Excel program.

Blogger news