Ask a new question

Using 2003 [Compatibility Mode] files in 2007 - Very Slow to Open, Insert Cells, Copy Cells, Undo, etc.

I am using Excel 2007 to edit Excel 2003 files. Files open in [Compatibility Mode], but are very slow to open, or use. For example, just to insert a row takes 30 seconds, copying a cell takes 20 seconds. When I use files originally created in Excel 2007 .xlsx, this problem does not come up. Please help.
Answer
Answer

Edit .xls file type

=============

1.     Click on Start > Control Panel.

2.     Double click on Folder Options and select File Types tab.

3.     Select DOC file type extension and click on Advanced.

4.     Highlight Open under actions and click Edit.

 

In the dialog box that appears you need to make two adjustments:

Application to perform action:

At the end of the line after /e append a space character followed by "%1" (including the quotes)

DDE Application Not Running:

Insert new text: [rem see command line] (including the brackets)

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 5, 2021 Views 2,392 Applies to: