Forum Discussion
Copy/paste no longer working in Excel
- 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.
OMGoodness sir, you have fixed my problem that has plagued me for months! I dont know why this worked when nothing else would, but by jove you have done it sir!
THANK YOU!!!!!