Editing Excel File on Compatibility Mode

Asked By kingruiz 0 points N/A Posted on - 10/26/2011

When using Excel 2007 under Compatibility Mode with Windows XP and Office 2003, there are certain things that I cannot do correctly.

It is when I cut, copy or paste any data into another spreadsheet, the picture mode will pop up and the data will lock.

If I open the data into 2007 and then cut, copy or paste, it become editable and can work again with the data.

How to resolve this? 

• Status: Open
• Question Views: 1644
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Clair griffin

Go To Solution

Best Answer

Best Answer

Answered By Clair griffin 10 points N/A #94298

Editing Excel File on Compatibility Mode

 

When working with Office Excel 2007, compatibility mode prevents new features in Office Excel 2007 from being saved to a file that will be edited in a previous version of Excel. If a user attempts to paste a content that is not supported by previous versions, compatibility mode downgrades the content to a form that is recognizable by the previous versions.

 

To minimize disruption to users who are collaborating between different versions of Excel, new features are limited in compatibility mode. To disable or exit compatibility mode, you must convert files to the system format. To detect features that are nit recognized by previous versions, use the Compatibility Checker.

About Clair griffin

Questions
1

Answers
132

Best Answers
38

• Vote Up 0 Vote Down

• Posted on - 10/26/2011
• Question Category: MS Excel

Answered By lee hung 75 points N/A #94299

Editing Excel File on Compatibility Mode

Hi Kingruiz,

Saving in the ms excel 97-2003 compatibility format is always the solution in most cases to problems arising between word 2007 and 2003. But in this case you are saying that you already saved your document in the format, but I will just ask you to confirm that by saving the document a fresh in another folder and see if that works.

Otherwise the problem could be a bug in the excel code, which may be needs that you make some modifications in the macros which you access by using the visual basic editors, by simply pressing ALT+11 on your keyboard.

There should be a code/module to fix that.

Regards,

Lee Hung

About lee hung

Questions
3

Answers
1451

Best Answers
463

• Vote Up 0 Vote Down

• Posted on - 10/26/2011
• Question Category: MS Excel