Share via

How to fix Microsoft.NET Framework "Value Does not fall within the expected range" error

Murathan Akhan 0 Reputation points
2024-04-03T09:40:50.61+00:00

Hello,

I have an Excel file linked with powerpoint for +50 graphs and tables. It was working fine until I linked the cell below:

="Average Deal Cycle is " & J3 & " Days" with some formatting, such as color and borders.

Now, when I want to update my powerpoint file, I encounter with .NET Framework errors.

Details are as below, can someone help me to solve the problem?

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************

Microsoft.Mashup.Client.Excel.Shim.NativeExcelException: Value does not fall within the expected range. ---> System.ArgumentException: Value does not fall within the expected range.

--- End of inner exception stack trace ---

at Microsoft.Mashup.Client.Excel.Interop.NativeExcelInteropUtils.ValidateResult(Int32 result, Int32[] expectedValues)

at Microsoft.Mashup.Client.Excel.NativeExcelFunctionsC2RBase.Microsoft.Mashup.Client.Excel.INativeExcelFunctions.TryGetParentWorkbook(IntPtr uiFrame, IntPtr& workbookPointer)

at Microsoft.Mashup.Client.Excel.Shim.NativeWindowContext.TryGetParentWorkbook(IWorkbook& workbook)

at Microsoft.Mashup.Client.Excel.CustomTaskPaneManagers.UpdateTaskPaneViewStates(IWindowContext windowContext)

at Microsoft.Mashup.Client.Excel.ExcelEventHandler.PerformPeriodicUpdate(IEnumerable`1 queriesTaskPaneVisibilityUpdateWindows)

at Microsoft.Mashup.Client.Excel.NativeEventHandler.<OnIdle>b__14_0()

at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

************** Loaded Assemblies **************

mscorlib

Assembly Version: 4.0.0.0

Win32 Version: 4.8.4400.0 built by: NET48REL1LAST_C

CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll

Microsoft.Mashup.Client.Excel

Assembly Version: 1.0.0.0

Win32 Version: 2.96.18808.0

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Client.Excel.dll

System

Assembly Version: 4.0.0.0

Win32 Version: 4.8.4360.0 built by: NET48REL1LAST_C

CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

Microsoft.Mashup.DocumentServices

Assembly Version: 1.0.0.0

Win32 Version: 2.96.18808.0

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.DocumentServices.DLL

Microsoft.Mashup.Client.UI

Assembly Version: 1.0.0.0

Win32 Version: 2.96.18808.0

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Client.UI.DLL

Microsoft.Mashup.Document

Assembly Version: 1.0.0.0

Win32 Version: 2.96.18808.0

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Document.DLL

Microsoft.MashupEngine

Assembly Version: 1.0.0.0

Win32 Version: 2.96.18808.0

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.MashupEngine.DLL

System.Core

Assembly Version: 4.0.0.0

Win32 Version: 4.8.4390.0 built by: NET48REL1LAST_C

CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

Microsoft.Mashup.Client.Models

Assembly Version: 1.0.0.0

Win32 Version: 2.96.18808.0

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Client.Models.DLL

System.Drawing

Assembly Version: 4.0.0.0

Win32 Version: 4.8.4390.0 built by: NET48REL1LAST_C

CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

Microsoft.Mashup.Client.Packaging

Assembly Version: 1.0.0.0

Win32 Version: 2.96.18808.0

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Client.Packaging.DLL

Microsoft.Mashup.Shims

Assembly Version: 1.0.0.0

Win32 Version: 2.96.18808.0

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Shims.DLL

System.Web.Extensions

Assembly Version: 4.0.0.0

Win32 Version: 4.8.4330.0

CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Web.Extensions/v4.0_4.0.0.0__31bf3856ad364e35/System.Web.Extensions.dll

System.Web

Assembly Version: 4.0.0.0

Win32 Version: 4.8.4330.0 built by: NET48REL1LAST_B

CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll

Microsoft.Practices.Unity

Assembly Version: 2.1.505.0

Win32 Version: 2.1.505.2

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Practices.Unity.DLL

Anonymously Hosted DynamicMethods Assembly

Assembly Version: 0.0.0.0

Win32 Version: 4.8.4400.0 built by: NET48REL1LAST_C

CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll

System.Windows.Forms

Assembly Version: 4.0.0.0

Win32 Version: 4.8.4400.0 built by: NET48REL1LAST_C

CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System.Configuration

Assembly Version: 4.0.0.0

Win32 Version: 4.8.4190.0 built by: NET48REL1LAST_B

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.8.4084.0 built by: NET48REL1

CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.Mashup.EventSource

Assembly Version: 1.0.0.0

Win32 Version: 2.96.18808.0

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.EventSource.DLL

System.Security

Assembly Version: 4.0.0.0

Win32 Version: 4.8.4261.0 built by: NET48REL1LAST_B

CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Security/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Security.dll

Microsoft.Mashup.ProviderShared

Assembly Version: 1.0.0.0

Win32 Version: 2.96.18808.0

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.ProviderShared.DLL

Microsoft.Mashup.OAuth

Assembly Version: 1.0.0.0

Win32 Version: 2.96.18808.0

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.OAuth.DLL

WindowsBase

Assembly Version: 4.0.0.0

Win32 Version: 4.8.4390.0 built by: NET48REL1LAST_C

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/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Document.XmlSerializers.DLL

System.Runtime.Remoting

Assembly Version: 4.0.0.0

Win32 Version: 4.8.4084.0 built by: NET48REL1

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.Client.Excel.Extensions

Assembly Version: 1.0.0.0

Win32 Version: 2.96.18808.0

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Client.Excel.Extensions.DLL

Microsoft.MashupEngine.Library45

Assembly Version: 1.0.0.0

Win32 Version: 2.96.18808.0

CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.MashupEngine.Library45.DLL

Microsoft.GeneratedCode

Assembly Version: 1.0.0.0

Win32 Version: 4.8.4084.0 built by: NET48REL1

CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.GeneratedCode

Assembly Version: 1.0.0.0

Win32 Version: 4.8.4084.0 built by: NET48REL1

CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Accessibility

Assembly Version: 4.0.0.0

Win32 Version: 4.8.4084.0 built by: NET48REL1

CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.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.

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,942 questions
PowerPoint Management
PowerPoint Management
PowerPoint: A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.Management: The act or process of organizing, handling, directing or controlling something.
232 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,731 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiachen Li-MSFT 32,451 Reputation points Microsoft Vendor
    2024-04-03T12:19:38.12+00:00

    Hi @Murathan Akhan ,

    Please try the following steps.

    1. Check Cell References, ensure that the cell reference (J3) in your Excel formula is correct and that it points to a valid cell containing a numerical value.
    2. Try removing the formula or using a different formula to see if the issue persists. This can help determine if the problem is specific to the formula you're using.
    3. Check Data Formatting, Ensure that the data in cell J3 is formatted correctly. Sometimes, formatting issues can cause errors when updating linked data.

    Best Regards.

    Jiachen Li

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.