1. The below error can be caused if the location that you are exporting the spreadsheet to, is synced to the cloud such as OnDrive or Box Sync.
Error: Failed to Export the Estimate.
2021-07-13 13:46:08,988 ERROR DE.Export.Spreadsheet.cExportEstimate [(null)] - An error occurred while performing the export
System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)).
at System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(RuntimeType objectType)
at System.Runtime.Remoting.Activation.ActivationServices.CreateInstance(RuntimeType serverType)
Resolution: Try exporting to the C-Drive instead or any folder that is not synced.
2. Another issue we have seen with users unable to Export or Import their spreadsheet to/from excel is this data in the log file.
2021-06-04 14:11:17,841 FATAL DEstimator.MainWindow [(null)] - Exception thrown to top level.
Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
Resolution: You have to run a repair on Office 365 to Repair Excel, which fixes the issue.