"Invalid data on clipboard" when using Paste TB import to import accounts from a Microsoft® Excel® file to a Trial Balance in CCH® ProSystem fx® Engagement or Workpaper Manager.

This error is caused by special characters or Microsoft® Excel® functions in the imported data, or by corrupted data in the Microsoft® Windows Clipboard. 

To resolve, complete the following:

  • Make sure that the Trial Balance is checked out to the user. 
   
  • Verify there are no frozen panes in Microsoft® Excel® by scrolling up and down, also left and right. If so, please go to View > Freeze Panes > Unfreeze Panes.
 
  • Ensure that both the  Microsoft® Excel® spreadsheet and Engagement or Workpaper Manager Trial Balance are in the same Microsoft® Excel® Instance.
  1. Close all Microsoft® Excel® workbooks that are open.
  2. If opened inside of Engagement or Workpaper Manager, click Tools > Options.
  3. Uncheck the option Launch Separate Instance of Excel.
  4. Re-open the import spreadsheet and retry to import the data.
  • Clear the Microsoft® Windows clipboard. 
  1. Click Start to open the Start menu. 
  2. Type cmd in the search bar.
  3. Right-click on the command prompt, and select "Run as Administrator."
  4. Type in the following command: echo off | clip
  5. Press ENTER. 
  6. Reboot the machine to clear the Windows clipboard and retry again to try and copy and paste TB import the data.
  • Import the data from another Microsoft® Excel® spreadsheet.
  1. Create a new blank Microsoft® Excel® spreadsheet and place it on the desktop or within the binder.
  2. Open the new Microsoft® Excel® spreadsheet.
  3. Open the original Microsoft® Excel® spreadsheet with the data to be imported into Trial Balance. 
  4. Highlight and copy the imported data from the original Microsoft® Excel® spreadsheet and paste the data as Value(s) onto the new Microsoft® Excel® spreadsheet.
  5. Proceed with Paste TB Import using the new Microsoft® Excel® spreadsheet with the data to be imported. 
  Solution Tools
  Attachments
 Solution Id 000030117/sw13642
 Direct Link
To provide feedback on this solution, please login.

Your feedback about this article will help us make it better. Thank you!