Forum Discussion
Copy/paste no longer working completely in Excel
4kchitsend - try upgrading the files. In Excel, click on the File menu, then Upgrade, or update or something. I don't have an XLS file around to see what the exact menu item is.
Then for grins, save it, close excel, and reopen. Does that fix it?
Tried the quick repair to no avail.
I opened a new Excel sheet and it copies and pastes into Word just fine. But multiple Excel files are not copying properly. Most were generated from Excel 1997 (a couple of computers ago) and whenever saving, a compatibility screen would pop up. I simply copy and paste onto a new spread sheet. I'm hoping I don't need to start over and create new originals. It is as if I clicked on a wrong item which only permits pasting as a photo or text.
4kchitsend - try upgrading the files. In Excel, click on the File menu, then Upgrade, or update or something. I don't have an XLS file around to see what the exact menu item is.
Then for grins, save it, close excel, and reopen. Does that fix it?
That did it. I never knew one had to manually update Excel. I assumed it automatically updated. The old files were .xls. The new are .xlsx Thanks for your suggestions. It is kind of you to assist. Enjoy your day.
4kchitsend wrote:That did it. I never knew one had to manually update Excel. I assumed it automatically updated. The old files were .xls. The new are .xlsx Thanks for your suggestions. It is kind of you to assist. Enjoy your day.
Excellent! No, Excel (or any office app) won't automatically convert them just in case there are specific reasons to keep the old format.
Keep in mind Excel probably didn't delete the old version either, so it is likely you have FileName.xls and FileName.xlsx still on your computer. Once you are ok with the new Filename.xlsx, you should delete the Filename.xls so you don't inadvertently go in there and edit that one then your workflow gets out of whack.