"Invalid data on clipboard" when using Paste TB import in CCH® ProSystem fx® Engagement or Workpaper Manager.

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

To resolve, complete the following:

  1. See our article on how to format data prior to using the Paste Trial Balance Import function.
  2. Ensure that both the Microsoft Excel spreadsheet and Engagement Trial Balance are in the same Microsoft Excel Instance.
    • If opened inside of Engagement, click Tools > Options.
    • Uncheck the option Launch Separate Instance of Excel.
  3. Clear the Windows clipboard. 
    • Click Start > Run. 
    • Type cmd in the search bar, and press ENTER.
    • Type in the following command: echo off | clip and press ENTER. 
    • Reboot the machine to clear the Windows clipboard.
  4. If the source spreadsheet is opened inside Engagement, only the source spreadsheet needs to be open.
    • Close the trial balance.
    • In the source spreadsheet, click importable range
    • Right-click the importable range and click Copy.
    • Right-click on the selected field and click Paste Trial Balance Import.
  5. If the source spreadsheet is opened outside of Engagement, both source spreadsheet and trial balance must be open. 
    • In the source spreadsheet click importable range. 
    • Right-click the importable range and click Copy. 
    • Click the Engagement Trial Balance and click Paste Trial Balance Import.
  6. If the issue persists, save the source spreadsheet to a Tab or Comma delimited text file.
    • Use the Import Conversion Wizard function to import your data.
    • In the source spreadsheet click Save As
    • Change the Save as type to Text (Tab delimited) (*.txt) or CSV (Comma delimited) (*.csv).
    • Save the file.
    • In the Engagement trial balance click Import > Import Conversion Wizard > ASCII Text File.
    • Browse to the location of the file, click Comma or Tab delimited
    • Click Next to import. 
  Solution Tools
  Attachments
 Solution Id sw13642
 Direct Link
Did this article answer your question or resolve your issue?

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