Error coming while running query - Resolving assembly Microsoft.Mashup.Document.XmlSerializers,Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35:Resolved as Default resolution

Question

Hi While running the Query in excel i am getting the below error but when i press ok 5-6 times on occurrence, the query runs finally and error doesn't re-occur.

Error :

Resolving assembly Microsoft.Mashup.Document.XmlSerializers,Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35:Resolved as Default resolution

i have done the below steps as highlighted in green advised by the chat gpt but didn't resolved the issue. need help to get rid off this error

It seems like you are encountering an issue related to the assembly "Microsoft.Mashup.Document.XmlSerializers" while running a query in Excel. This type of issue may occur due to various reasons, and troubleshooting it might involve a few steps. Here are some general steps you can take to address this problem:

1. Check for Updates: Ensure that both Excel and any related add-ins or extensions are up to date. Microsoft frequently releases updates that address compatibility issues and bugs.
2. Repair Office Installation: Try repairing your Microsoft Office installation. You can do this by going to the "Control Panel" > "Programs" > "Programs and Features," finding Microsoft Office in the list, and choosing the "Repair" option.
3. Disable Add-ins: Disable any unnecessary Excel add-ins and then try running the query again. Add-ins can sometimes conflict with each other or with Excel functionalities.
4. Clear Cache: Clear the cache used by Power Query. In Excel, go to "File" > "Options" > "Data" and click on the "Clear All" button under the "Data loading" section.

Answer 1

Hi Vikas S,

Thank you for reaching out. My name is Leo, a user just like you. I'd be happy to help you with your concern.

May I know which Microsoft Office version you are currently using? Also, could you specify the particular query you are attempting to run? Do you use any add-ins? What changes were made that might be causing the issue? Does the issue also occur in other documents, or is it specific to that particular document? It would be very helpful if you could provide a screenshot of the issue for us to better understand it.

As part of the troubleshooting steps, I recommend repairing your Office by using the online repair tool. Follow the steps below:

"1. Access this link to download the Office repair tool. Link: https://aka.ms/SaRA-officeUninstallFromPC 2. Download and install it, then open to run.

Tip: The tool may take a few minutes to download and install. After completing the installation, the Uninstall Office products window will open.

3. Select the version you want to uninstall, and then select Next.
4. Follow through the remaining screens and when prompted, restart your computer.

After you restart your computer, the uninstall tool automatically re-opens to complete the final step of the uninstall process. Follow the remaining prompts.

5. Select the steps for the version of Office you want to install or reinstall. Close the uninstall tool."

After you completed the steps to repair, you will need to restart your computer and try to access your Microsoft Excel again. In case the issue still persists, please don't hesitate to let us know. We the community users are always here to help. Thank you!

I pulled the above steps from Official Microsoft Support website. For reference, here's the link below:

https://support.microsoft.com/office/7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

Your understanding and patience will be highly appreciated. I hope I provided a helpful information regarding your concern! Let me know if you have any further questions. Be safe always!

Best Regards,

Leo