We appreciate your time getting in touch with the Community, B91744.
Given that you've completed different methods of troubleshooting, there are a few workarounds we can perform with copying multiple entries. I'd be glad to discuss this in detail and guide you on how to fix this.
To avoid getting user restrictions, I recommend opening your QuickBooks Desktop (QBDT) company file using the admin credentials. If you're accessing the company file remotely, you can create a copy and save it in the Excel file locally.
Once you open the file successfully, copy and paste the entries again to see if it works. If you get the same result, run the repair tool via the Control Panel.
To fix QBDT software via the Control Panel, please follow the steps below:
- Backup the company file to avoid data loss.
- Reboot the system and ensure that there are no programs affecting the repairs.
- Open the Windows start menu, and choose the control panel.
- If you're using Windows 8, look for the Control Panel in the Windows start menu.
- Choose programs and features, along with uninstall the program.
- If you cannot spot the programs and features, then opting for the program is recommended.
- Move ahead to QuickBooks from the list of programs, and then choose the uninstall/change option.
- Click Continue, followed by hitting the Next button.
- Click on Repair and also hit Next.
- Finally, select the Finish tab.
Once completed, open the QBDT company file and install the latest updates. Here's how:
- Go to the Help menu.
- Select Update QuickBooks Desktop on the dropdown.
- Choose the Update Now tab.
- Tick the Reset updates box, then click Get Updates.
- Once done, close and reopen QuickBooks.
After installing the latest software update, copy and paste list information from Excel directly into QuickBooks. I recommend referring to this article for detailed information on the process: Add and edit multiple customers, vendors, and items.
Additionally, you may refer to this article for more insights and information into importing and exporting QuickBooks data with MS Excel files: Import or export MS Excel files.
If you have further questions about troubleshooting-related concerns in QuickBooks Desktop, please feel free to reach out. I will be checking this thread from time to time. Have a productive day!
