Excel’s data transfer on Windows 7 Pro with Office ’10

Asked By Paul Willard 0 points N/A Posted on - 12/20/2011

Dear friends,

My PC runs on Windows 7 Pro (64-bit Traditional Chinese) and has Office ’10 (32-bit Trad Chinese) and IBM Client Access V6R1M0 (64-bit English).  When using Excel’s data transfer, the values change to 10 or 20 instead of the actual 1 or 2.  This occurs randomly.  

Any thoughts? Please share them with me, it would be of great help.

Paul

• Status: Open
• Question Views: 991
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Windows 7

Answered By Clair Charles 15 points N/A #123483

Excel’s data transfer on Windows 7 Pro with Office ’10

You will need to make sure that you are using the ms excel 2010 in the compatibility mode for it to be able to work with the earlier versions of Excel, such as Excel 97-2003 or Excel 2007, and that way, you will be able to exchange workbooks between the different versions without encountering such problems.

To save the files in the compatibility mode, you will need to:

• Open the excel document.
• And then click on file, and then choose save as.
• You will then need to choose the excel 97-2003 compatibility format.
• And then save the file.

That should help solve the problem.

-Clair Charles

 

About Clair Charles

Questions
1

Answers
495

Best Answers
109

• Vote Up 0 Vote Down

• Posted on - 12/21/2011
• Question Category: Windows 7