Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-11-2017, 12:44 PM
bkcell bkcell is offline clipboard error freezes workbook Windows 7 64bit clipboard error freezes workbook Office 2007
Advanced Beginner
clipboard error freezes workbook
 
Join Date: Jul 2011
Posts: 35
bkcell is on a distinguished road
Default clipboard error freezes workbook

I have a new machine with fresh installs of win10 pro and office 2016. an old annoyance has survived the transition. in Excel, occasionally an error message pops up "there's a problem with the clipboard but you can still paste your content within this workbook." after this, the paste occurs but the workbook is then frozen, not responsive to keyboard or mouse inputs. other workbooks still respond normally. the only fix I've found so far is to restart Excel. this was occurring in the previous 2013 install on another machine. I ran a clear clipboard routine with no effect. this occurs when pasting between workbooks and within a workbook. any thoughts?
Reply With Quote
  #2  
Old 06-18-2017, 01:02 PM
Logit Logit is offline clipboard error freezes workbook Windows 10 clipboard error freezes workbook Office 2007
Expert
 
Join Date: Jan 2017
Posts: 533
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Does it occur when pasting between "old / existing" workbooks ? Or does it also occur when you are using newly created workbooks on the new system ? They were not already existing prior to the new install ?

If the new workbooks are affected, it must be something in the old workbooks you carried over to the new system. Code, corruption, etc.
Reply With Quote
  #3  
Old 06-18-2017, 01:36 PM
bkcell bkcell is offline clipboard error freezes workbook Windows 10 clipboard error freezes workbook Office 2016
Advanced Beginner
clipboard error freezes workbook
 
Join Date: Jul 2011
Posts: 35
bkcell is on a distinguished road
Default

the data/workbooks are pre-existing. is there a simple way to audit the files for errors?
Reply With Quote
  #4  
Old 06-18-2017, 02:29 PM
Logit Logit is offline clipboard error freezes workbook Windows 10 clipboard error freezes workbook Office 2007
Expert
 
Join Date: Jan 2017
Posts: 533
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

RESTORE CORRUPT FILE

I would try these steps, in the order presented. Each has been used here many times. Sometimes they work,
sometimes they don't.


NOTE: ALWAYS USE THESE STEPS ON A COPY OF YOUR WORKBOOK, NOT THE ORIGINAL. If something
goes wrong you haven't lost the original.

#1
My favorite first attempt is to use this free program. It's safe, I've used it many times when downloaded straight from the author :

https://excelfilecleaner.codeplex.co...ses/view/85025
================================================== ===============================


#2
https://support.office.com/en-us/art...A-801DDCD4EA53
================================================== ===============================


#3
If you're having a problem with an Excel file, save it as HTML (which is one of the file types in Excel), then save it back to .xls

They say that will often recover lost information, or restore a corrupt file.
================================================== ===============================


#4
Another way of restoring broken/corrupted Excel files

I've been quite lucky actually opening corrupted files in OpenOffice, saving them, and then re-opening them in Excel. Sometimes the formatting will be a little off, but the data is almost always recovered, as well as most of the formatting. Unfortunately, not all of the formula and charts are, but when it happened I was happy anything was salvaged at all. ================================================== ================================


#5
http://directory.s2services.com/excel.htm
================================================== ================================

.
Reply With Quote
  #5  
Old 06-18-2017, 08:00 PM
bkcell bkcell is offline clipboard error freezes workbook Windows 10 clipboard error freezes workbook Office 2016
Advanced Beginner
clipboard error freezes workbook
 
Join Date: Jul 2011
Posts: 35
bkcell is on a distinguished road
Default

thanks very much, i'll try'em all!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
data entered in one workbook should be updated in other relevant workbook based on the date vedha Excel 0 04-24-2015 08:45 PM
Getting the clipboard value: Dataobject error arjfca Word VBA 0 12-04-2014 01:51 AM
clipboard error freezes workbook #REF! error when opening a workbook that contain a refference to another workbook tanababa Excel 2 06-07-2012 03:11 PM
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? tinfanide Excel Programming 1 02-09-2012 04:08 PM
clipboard error freezes workbook macro to transfer data from one workbook to another workbook virsojour Excel Programming 5 02-01-2011 08:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft