Excel 2016内置power query后，打开新建查询-从文件夹，提示：“Microsoft.Mashup....

314336407

Excel 2016内置power query后，打开新建查询-从文件夹，提示：“Microsoft.Mashup.Storage.Xml`1”的类型初始值设定项引发异常。
C:\Users\Administrator\Desktop\`2M2~U2~YUT}G87U}`R5O3M.png
详细信息如下：
错误消息:

“Microsoft.Mashup.Storage.Xml`1”的类型初始值设定项引发异常。

堆栈跟踪:

System.TypeInitializationException: “Microsoft.Mashup.Storage.Xml`1”的类型初始值设定项引发异常。 ---> System.IO.FileNotFoundException: 未能找到文件“C:\Users\Administrator\AppData\Local\Temp\fjyan6i_.dll”。
文件名:“C:\Users\Administrator\AppData\Local\Temp\fjyan6i_.dll”
   在 System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   在 System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
   在 System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
   在 Microsoft.CSharp.CSharpCodeGenerator.FromFileBatch(CompilerParameters options, String[] fileNames)
   在 Microsoft.CSharp.CSharpCodeGenerator.FromSourceBatch(CompilerParameters options, String[] sources)
   在 Microsoft.CSharp.CSharpCodeGenerator.System.CodeDom.Compiler.ICodeCompiler.CompileAssemblyFromSourceBatch(CompilerParameters options, String[] sources)
   在 System.CodeDom.Compiler.CodeDomProvider.CompileAssemblyFromSource(CompilerParameters options, String[] sources)
   在 System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns, XmlSerializerCompilerParameters xmlParameters, Evidence evidence)
   在 System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, Evidence evidence, XmlSerializerCompilerParameters parameters, Assembly assembly, Hashtable assemblies)
   在 System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, String location, Evidence evidence)
   在 System.Xml.Serialization.XmlSerializer.GenerateTempAssembly(XmlMapping xmlMapping, Type type, String defaultNamespace)
   在 System.Xml.Serialization.XmlSerializer..ctor(Type type, String defaultNamespace)
   在 System.Xml.Serialization.XmlSerializer..ctor(Type type)
   在 Microsoft.Mashup.Storage.Xml`1..cctor()
   --- 内部异常堆栈跟踪的结尾 ---
   在 Microsoft.Mashup.Storage.Xml`1.SerializeBytes(T value)
   在 Microsoft.Mashup.Host.Document.PackageConfigExtensions.SetPackageConfig(PackageEditor packageEditor, PackageConfig packageConfig)
   在 Microsoft.Mashup.Host.Document.PackageConfigExtensions.AddDefaultConfigToPackage(PackageEditor packageEditor)
   在 Microsoft.Mashup.Host.Document.Storage.PackageStorageManager.CreatePackage(PackagePath packagePath)
   在 Microsoft.Mashup.Client.Excel.WorkbookPackageInfo.CreateNew(ExcelServices excelServices, PackageManager packageManager, IWorkbookIdentity workbookIdentity)
   在 Microsoft.Mashup.Client.Excel.PackageManager.InitializeWorkbookPackageInfo(IWorkbook workbook, IWorkbookIdentity workbookIdentity, Boolean allowCreateNew)
   在 Microsoft.Mashup.Client.Excel.PackageManager.EnsureWorkbookPackageInfo(IWorkbook workbook, Boolean allowCreateNew)
   在 Microsoft.Mashup.Client.Excel.DialogManager.TryEnsureConnectionsEnabledAndPackageCreated(IWin32Window ownerWindow, IWorkbook workbook, WorkbookPackage& workbookPackage)
   在 Microsoft.Mashup.Client.Excel.DialogManager.AddSource(IWindowContext windowContext, IWorkbook workbook, IQueryServices queryServices, String sourceID)
   在 Microsoft.Mashup.Client.Excel.ExcelRibbonHandler.<>c__DisplayClass1.<OnSourceButtonAction>b__0(IWorkbook workbook)
   在 Microsoft.Mashup.Client.Excel.Shim.IWindowContextExtensions.TryInvokeOnParentWorkbook(IWindowContext windowContext, Action`1 action)
   在 Microsoft.Mashup.Client.Excel.ExcelRibbonHandler.OnSourceButtonAction(IWindowContext windowContext, String sourceID)
   在 Microsoft.Mashup.Client.Excel.NativeRibbonHandler.<>c__DisplayClass1.<OnRibbonButtonAction>b__0()
   在 Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

调用堆栈跟踪:

   在 Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   在 Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
   在 Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   在 Microsoft.Mashup.Client.Excel.NativeRibbonHandler.OnRibbonButtonAction(IntPtr uiFrame, Int32 buttonID)
   在 Microsoft.Mashup.Client.Excel.NativeExcelConnector.<>c__DisplayClass6f.<OnRibbonButtonActionCallback>b__6e()
   在 Microsoft.Mashup.Client.Excel.NativeExcelConnector.InvokeAndReturnHResult(Action action)
   在 Microsoft.Mashup.Client.Excel.NativeExcelConnector.OnRibbonButtonActionCallback(IntPtr uiFrame, Int32 buttonID)

314336407

请知道的朋友帮忙解释下，并怎么解决问题，非常感谢！！！

314336407

Excel 2016内置power query后，打开新建查询-从文件夹，提示：“Microsoft.Mashup.Storage.Xml`1”的类型初始值设定项引发异常。

danfal2019

我也遇到一样的问题

tangziyao80

我遇到类似问题，重新装了OFFICE，就解决了

314336407

tangziyao80 发表于 2019-5-15 12:47
我遇到类似问题，重新装了OFFICE，就解决了

我也重装了，但是还不行，你电脑里没有2007版或者wps吧？