none
frown error RRS feed

  • Question

  • Hi,

    I keep receiving this error when trying to download data from Oracle DB via VBA (MS Query).

    I think it might relate to Power Query cause it started popping up after I opened the Power Query window and closed it without actually doing anything.

    Could you help?

    Jarek

    Feedback Type:
    Frown (Error)
    
    Error Message:
    Value does not fall within the expected range.
    
    Stack Trace:
       at Microsoft.Mashup.Client.Excel.NativeExcelFunctionsBase.ValidateResult(Int32 result, Int32[] expectedValues)
       at Microsoft.Mashup.Client.Excel.NativeExcelFunctionsMSI.Microsoft.Mashup.Client.Excel.INativeExcelFunctions.GetConnectionProperties(IntPtr workbookPointer, String connectionName)
       at Microsoft.Mashup.Client.Excel.NativeEventHandler.<>c__DisplayClass26.<OnListObjectCreated>b__25()
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
    
    Stack Trace Message:
    Value does not fall within the expected range.
    
    Invocation Stack Trace:
       at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
       at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
       at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Exception exception)
       at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, WindowsHost windowsHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
       at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
       at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback)
       at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       at Microsoft.Mashup.Client.Excel.NativeEventHandler.OnListObjectCreated(IntPtr workbookPointer, String listObjectName)
       at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.<>c__DisplayClass92.<OnListObjectCreated>b__91()
       at Microsoft.Mashup.Client.Excel.ExcelCallbackManager.InvokeAndReturnHResult(Action action)
       at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.OnListObjectCreated(IntPtr workbookPointer, String listObjectName)
    
    
    Supports Premium Content:
    True
    
    

    • Moved by Steve Fan Monday, May 28, 2018 7:57 AM Power Query related
    Friday, May 25, 2018 11:07 AM

Answers

  • Hi Jarek,

    Thanks for reporting this issue.

    The Office version you are using is not up-to-date. We've had many updates during the last 2 years to the version you are using.

    Is it possible that you update to the latest Office version and see if the issue you are experiencing still happens?

    Thank you,

    Dan Polak from the Excel team.

    Wednesday, May 30, 2018 10:28 AM

All replies

  • ...just to add:

    Win 10 Enterprise 10.0.15063

    MS Office Excel 2016 MSO (16.0.4266.1001) 32-bit

    Friday, May 25, 2018 11:32 AM
  • Hi Jarek,

    Welcome to the Office 2016 and Office 365 ProPlus IT Pro General Discussions forum. This forum is for general questions and feedback related to Microsoft Office applications. Since your question is more related to Power Query, I'll move it to the dedicated Power Query forum:

    https://social.technet.microsoft.com/Forums/office/en-US/home?forum=powerquery

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding. 

    Regards,
    Steve Fan


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Monday, May 28, 2018 7:55 AM
  • Hi Jarek,

    Thanks for reporting this issue.

    The Office version you are using is not up-to-date. We've had many updates during the last 2 years to the version you are using.

    Is it possible that you update to the latest Office version and see if the issue you are experiencing still happens?

    Thank you,

    Dan Polak from the Excel team.

    Wednesday, May 30, 2018 10:28 AM