Hello Afeef,
I'm Ibhadighi and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.
The error message you're encountering when trying to export a Pronto Xi XML document to Excel and receiving "This action cannot be completed because the 'Book1 - Excel' program is not responding, choose 'Switch To' and correct the problem" suggests there's an issue with Excel handling the exported file. Here are simple steps to try and resolve this:
- Ensure that no other heavy programs are running that might be affecting your computer's performance.
- Close Excel and any other Office applications, then reopen them. Try to perform the export again.
- Make sure your Office 2016 is up to date. Microsoft releases updates that can fix issues and improve performance.
- Use the repair feature in the Control Panel (Programs > Programs and Features > Select Microsoft Office > Change > Repair) to fix any issues with your Office installation.
- Ensure the XML file is not too large or complex for Excel to handle. If possible, try opening a smaller or simpler XML file to see if the problem persists.
- Sometimes, simply restarting your computer can resolve underlying issues causing the problem.
If the issue continues after trying these steps, there may be a more specific problem with your Excel installation or the XML file itself that requires further troubleshooting.
I hope this helps.
Best Regards,
Ibhadighi