Problem With Copy & Paste In Excel 2010

0 votes
asked Apr 20, 2017 in MS Excel Issues by Kelvin

Currently I am using excel  2010 on windows 7 and I am facing issue with the copy and paste command. I am trying hard to copy the formula used in one cell to another but it doesn’t work. When I use the paste special the only option shown are Unicode text or text, with no explanation. I have tried uninstalling and reinstalling Office 2010 suit, but the problem persists the same. Please suggest me some idea.

1 Answer

0 votes
answered Apr 20, 2017 by taylor (350 points)

When I rendered through the same situation I followed the following steps:

  1. Close Excel.
  2. Go to Documents and Settings > Application Data > Microsoft > Excel > XLSTART. The folder contains a PERSONAL.XLS and PERSONAL.XLSB file.
  3. Assuming Office 2000 and Office 2007 have been installed in separate directories in Program Files:
    – Move the PERSONAL.XLS file to Program Files > Microsoft Office > Office > XLStart
    – Move the PERSONAL.XLSB file to Program Files > Microsoft Office 2007 (or however it’s named) > Office 12 > XLSTART.
    Don’t just copy the files–move them. The original folder should be empty.
  4. Restart Excel 2000.
Welcome to Q&A - Repair MS Excel File, where you can ask questions and receive answers from other members of the community.