Forum Discussion
Solved
Copy/paste no longer working in Excel
Sometime in the last few months the copy/paste function within Excel (Office 365 version) stopped working for me. I have updated Windows and all Office apps to the latest version but that hasn't fix...
- I’d recommend that everyone having thus issue goes to File > Feedback and send a frown, putting your details in the section and start it [Can’t Copy Paste]
Also what version is everyone in who’s having this problem ? File > Account
It will read something like
Semi Annual Channel
Build 1234.567
This is what broke my cut-and-paste abiltiy in Excel. Jon Firooz
I produce some spreadsheets programmatically with powershell in a scheduled task.
This only works if you add these directories to your machine
C:\Windows\System32\config\systemprofile\Desktop
C:\Windows\SysWOW64\config\systemprofile\Desktop
That solution comes from here.
https://superuser.com/questions/579900/why-cant-excel-open-a-file-when-run-from-task-scheduler
When you add those directories your cut and paste in excel will stop working. It is real time, you do not even need to open/close excel. Open a spreadsheet add those directories cut and paste in excel will stop working. Remove those directories it will start working again. The issue is that MS does not test their stuff to be run in an automated way, everything is based on user interaction, another link within the page above.
https://support.microsoft.com/en-us/help/257757/considerations-for-server-side-automation-of-office
All current versions of Microsoft Office were designed, tested, and configured to run as end-user products on a client workstation. They assume an interactive desktop and user profile. They do not provide the level of reentrancy or security that is necessary to meet the needs of server-side components that are designed to run unattended.
Thanks!
