none
file temp.User.zip being used by another process RRS feed

  • Question

  • After installing Power Query I keep getting this error:

    "The process cannot access the file 'C:\Users\0800\AppData\Local\Microsoft\Power Query\temp.User.zip' because it is being used by another process."

    It happens even if there’s only one instance of Excel running. I believe it has something to do with the auto-save feature, but I’m not sure.
    Fortunately it allows me to save the Excel file I'm working without any problem.


    Tuesday, November 18, 2014 4:01 PM

Answers

  • Can you provide the stack trace? You can also try to use handle.exe to see what processes are holding onto that file.

    Ehren

    Friday, December 5, 2014 8:17 PM
    Owner
  • Hi Guy,

    Do you keep seeing this error when running Excel? Is User.zip (in the same directory as temp.User.zip) marked as read-only? When did you see this error (e.g. when Excel started up, when Excel shut down, etc.)

    If you send a frown it can help out since it will give us a stack trace.

    Thanks.

    Friday, January 16, 2015 1:01 AM
  • Hi Alejandro,

    Sorry, the error has gone now. I assume it disappeared after a reboot, but I wasn't really paying attention.

    When I was getting the problem, it was during Excel starting up. I can't say what state User.zip had; all I can see now is that temp.User.zip is no longer in that folder, and I don't get the error.
    Friday, January 16, 2015 10:29 PM

All replies

  • Does it still happen after rebooting your PC? Did you have to disable auto-save in order to stop getting this error message?

    Ehren

    Tuesday, December 2, 2014 7:24 PM
    Owner
  • Yes it happens even after a reboot. And yes, I had to disable the auto-save feature.

    Thanks.

    Luís

    Friday, December 5, 2014 6:01 PM
  • Can you provide the stack trace? You can also try to use handle.exe to see what processes are holding onto that file.

    Ehren

    Friday, December 5, 2014 8:17 PM
    Owner
  • Handle.exe didn't find any processes holding such a file.

    Here's the stack trace from the error message (thanks again):

    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.UnauthorizedAccessException: Access to the path 'C:\Users\0800\AppData\Local\Microsoft\Power Query\temp.User.zip' is denied.
       at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
       at 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, Boolean useLongPath, Boolean checkHost)
       at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
       at Microsoft.Mashup.Host.Document.Storage.Local.SharedLocalStorageAccessor.<Access>b__1()
       at Microsoft.Mashup.Host.Document.Storage.Local.SharedLocalStorageAccessor.EnsureFolderCreated(Action action)
       at Microsoft.Mashup.Host.Document.Storage.Local.SharedLocalStorageAccessor.<Access>b__0(SharedLocalStorage sharedLocalStorage)
       at Microsoft.Mashup.Host.Document.Storage.Local.SharedLocalStorageAccessor.SharedLocalStorage.Dispose()
       at Microsoft.Mashup.Host.Document.Storage.Local.LocalUISettingsStorage.SetSettings(MetadataSet metadataSet)
       at Microsoft.Mashup.Host.Document.Storage.TracingUISettingsStorage.SetSettings(MetadataSet metadataSet)
       at Microsoft.Mashup.Host.Document.UISettings.SetStringSetting(String settingName, String value)
       at Microsoft.Mashup.Host.Document.Formulas.FormulaHistoryManager.SaveHistory()
       at Microsoft.Mashup.Client.Excel.AddIn.Extensibility.IDTExtensibility2.OnDisconnection(ext_DisconnectMode disconnectMode, Array& custom)


    ************** Loaded Assemblies **************
    mscorlib
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
    ----------------------------------------
    Microsoft.Mashup.Client.Excel
        Assembly Version: 1.0.0.0
        Win32 Version: 2.17.3850.242
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Client.Excel.dll
    ----------------------------------------
    Extensibility
        Assembly Version: 7.0.3300.0
        Win32 Version: 7.00.9466
        CodeBase: file:///C:/Windows/assembly/GAC/Extensibility/7.0.3300.0__b03f5f7f11d50a3a/Extensibility.dll
    ----------------------------------------
    office
        Assembly Version: 15.0.0.0
        Win32 Version: 15.0.4667.1001
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/office/15.0.0.0__71e9bce111e9429c/office.dll
    ----------------------------------------
    Microsoft.Mashup.Client.Windows
        Assembly Version: 1.0.0.0
        Win32 Version: 2.17.3850.242
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Client.Windows.DLL
    ----------------------------------------
    Microsoft.Mashup.Document
        Assembly Version: 1.0.0.0
        Win32 Version: 2.17.3850.242
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Document.DLL
    ----------------------------------------
    System
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34238 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    Microsoft.Mashup.Engine.Interface
        Assembly Version: 1.0.0.0
        Win32 Version: 2.17.3850.242
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Engine.Interface.DLL
    ----------------------------------------
    System.Core
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
    ----------------------------------------
    Microsoft.Mashup.OleDbProvider
        Assembly Version: 1.0.0.0
        Win32 Version: 2.17.3850.242
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.OleDbProvider.DLL
    ----------------------------------------
    System.Windows.Forms
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    ----------------------------------------
    System.Drawing
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    Microsoft.Office.Interop.Excel
        Assembly Version: 15.0.0.0
        Win32 Version: 15.0.4569.1506
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Interop.Excel/15.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll
    ----------------------------------------
    System.Web.Mvc
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50217.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/System.Web.Mvc.DLL
    ----------------------------------------
    System.Web.Routing
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Web.Routing/v4.0_4.0.0.0__31bf3856ad364e35/System.Web.Routing.dll
    ----------------------------------------
    System.Web
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll
    ----------------------------------------
    Microsoft.Mashup.Client.Models
        Assembly Version: 1.0.0.0
        Win32 Version: 2.17.3850.242
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Client.Models.DLL
    ----------------------------------------
    EventSource
        Assembly Version: 1.0.0.0
        Win32 Version: 1.0.2236.3
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/EventSource.DLL
    ----------------------------------------
    System.Configuration
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    ----------------------------------------
    System.Xml
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    Microsoft.mshtml
        Assembly Version: 7.0.3300.0
        Win32 Version: 7.0.3300.0
        CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.mshtml/7.0.3300.0__b03f5f7f11d50a3a/Microsoft.mshtml.dll
    ----------------------------------------
    Microsoft.Mashup.Engine.1
        Assembly Version: 1.0.0.0
        Win32 Version: 2.17.3850.242
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Engine.1.DLL
    ----------------------------------------
    System.Data
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
    ----------------------------------------
    System.Runtime.Remoting
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34245 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
    ----------------------------------------
    Microsoft.Mashup.Storage
        Assembly Version: 1.0.0.0
        Win32 Version: 2.17.3850.242
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Storage.DLL
    ----------------------------------------
    Microsoft.Mashup.Evaluator
        Assembly Version: 1.0.0.0
        Win32 Version: 2.17.3850.242
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Evaluator.DLL
    ----------------------------------------
    System.ServiceModel
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll
    ----------------------------------------
    WindowsBase
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
    ----------------------------------------
    Microsoft.Mashup.Document.XmlSerializers
        Assembly Version: 1.0.0.0
        Win32 Version: 1.0.0.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Document.XmlSerializers.DLL
    ----------------------------------------
    Microsoft.Mashup.OleDb
        Assembly Version: 1.0.0.0
        Win32 Version: 2.17.3850.242
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.OleDb.DLL
    ----------------------------------------
    System.Web.Extensions
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Web.Extensions/v4.0_4.0.0.0__31bf3856ad364e35/System.Web.Extensions.dll
    ----------------------------------------
    CustomMarshalers
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/CustomMarshalers/v4.0_4.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
    ----------------------------------------
    Microsoft.Mashup.Storage.XmlSerializers
        Assembly Version: 1.0.0.0
        Win32 Version: 1.0.0.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Storage.XmlSerializers.DLL
    ----------------------------------------
    System.Security
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Security/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Security.dll
    ----------------------------------------
    Microsoft.Mashup.DocumentHost
        Assembly Version: 1.0.0.0
        Win32 Version: 2.17.3850.242
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.DocumentHost.DLL
    ----------------------------------------
    Accessibility
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
    ----------------------------------------
    Microsoft.Exchange.WebServices
        Assembly Version: 15.0.0.0
        Win32 Version: 15.00.0516.014
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Exchange.WebServices.DLL
    ----------------------------------------
    System.Web.Abstractions
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34209
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Web.Abstractions/v4.0_4.0.0.0__31bf3856ad364e35/System.Web.Abstractions.dll
    ----------------------------------------

    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.

    For example:

    <configuration>
        <system.windows.forms jitDebugging="true" />
    </configuration>

    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the computer
    rather than be handled by this dialog box.


    Thursday, December 11, 2014 11:42 AM
  • I, too, am having the same problem.  The message pops up when I try to close Excel.

    Jeane N. Meade

    Friday, December 26, 2014 3:54 PM
  • If you go to "%LocalAppData%\microsoft\Power Query\", is there a file called temp.User.zip? If there is, is it read-only? You can check by right-clicking on the file, choosing Properties, and seeing if the Read-only attribute is checked.

    Deleting the temp.User.zip file should work around this issue. We are trying to figure out when this occurs, though. Did Excel crash shortly before you started seeing this issue?

    Thanks.

    Wednesday, January 14, 2015 1:06 AM
  • Hi Alejandro,

    I started seeing this error today. My Excel did not crash recently (that I remember). I did get some Windows Updates yesterday; six for Windows and one for IE Flash Player. I can give you the KB numbers it you like.

    I do have a temp.User.zip file in the location you mention. It is not Read-only. I did not delete it, yet, since I don't need to use Power Query right now.

    I run Windows 8.1 64bit, Office Professional Plus 2013 32bit, Excel 15.0.4675.1000 and Power Query 2.17.3850.242.

    If I can provide you with any other useful information, please let me know.

    Guy

    Thursday, January 15, 2015 9:31 AM
  • Hi Guy,

    Do you keep seeing this error when running Excel? Is User.zip (in the same directory as temp.User.zip) marked as read-only? When did you see this error (e.g. when Excel started up, when Excel shut down, etc.)

    If you send a frown it can help out since it will give us a stack trace.

    Thanks.

    Friday, January 16, 2015 1:01 AM
  • Hi Alejandro,

    Sorry, the error has gone now. I assume it disappeared after a reboot, but I wasn't really paying attention.

    When I was getting the problem, it was during Excel starting up. I can't say what state User.zip had; all I can see now is that temp.User.zip is no longer in that folder, and I don't get the error.
    Friday, January 16, 2015 10:29 PM
  • I haven't been getting this error lately. Maybe the latest power query update solved this issue.
    Tuesday, February 10, 2015 12:12 PM