Hi,

I am receiving the error "9020 We couldn't copy this sheet." I am unable to figure out what is causing the error when I try to export a table.  I'm running on Excel 365.  Any ideas, what could be causing it?

Hi Nick,

I get the error only while exporting a chemistry table.

I am able to export directly to excel clicking the 'excel' button. 

I am also able to create a QA/QC table as well. Only seem to have recieved the error when i try to export a Chem Table. 

After i receive the error, 2 excel tables open up that are empty.  They are the "Chemistry_Output_Table" & "Chemistry_Output_Table_Template"

I'm running Excel 365 in my PC.  The other user is running MS 2010 and has no issue.

Jufar

Hi Nick,

I still get the same error, even with the original templates from the installation of the program.

Jufar

Hi Jufar,

Are you able to compare your template and network folder setup with that of the user that is working?  If these aren't the same, can you update your settings to match?

Otherwise, could you please look at the following questions and provide a little bit more information.  This will assist in identifying the cause of the problem.

• Did it just start happening?
• Did anything change on your PC that you are aware of between when it wasn't happening, and when it started happening?
• Does it happen for more than one existing project?
• Does it happen for new projects? / the Sample Project?
• Does it happen if someone else tries it under their Windows Login on the same PC?
• Does doing a “Repair” on Excel resolve it?
• If it's just started happening, does uninstalling recent Excel or Office "Patches" resolve it?
• Does reinstalling Excel resolve it?

If you could investigate and provide answers for these it would be great.

Thanks,

Nick

Hi All,

We've had others report this too, today.  It looks like an update or patch to some versions of Excel at some companies has been deployed overnight, which is now causing that error.  

We occasionally see this with Excel updates, and they are usually fixed by Microsoft soon afterwards.  It can also typically be resolved by reverting the specific patch that created the error (or by doing a system restore to a date before the patch).

Can you let me know what version of Excel you are running (from the information we have at the moment it looks to be occuring only for those using Excel as a part of Office 365), and a screenshot of the Updates or  Patches appled to Excel in the last few days?  

Warwick

Edited by user Tuesday, June 4, 2019 3:29:03 PM(UTC)  | Reason: Not specified

For those who do want to immediately roll back that Excel patch the instructions are at:

https://support.microsoft.com/en-us/help/2770432/how-to-revert-to-an-earlier-version-of-office-2013-or-office-2016-clic

Rolling back to a May version seems to resolve the issue.  https://docs.microsoft.com/en-us/officeupdates/update-history-office365-proplus-by-date?redirectSourcePath=%252fen-us%252farticle%252fae942449-1fca-4484-898b-a933ea23def7

You will need admin permissions to be able to do that.

Warwick

Any news on whether MicroSoft have a patch on the way that rectifies the problem? I've been holding out rolling everyone back, but may have to if one isnt forthcoming.

Hi Jufar,

Thanks for the update. 

I have installed updates and can confirm that Build 11629 appears to have resolved the issue with the Excel export now working again as expected.

Nick