web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Error when upload excel

(0) ShareShare
ReportReport
Posted on by 34

Hi Guys,

Do you why I'm getting this error when trying to upload an excel ?

"The value of Seek/OffsetFromEnd parameter is outside of the permitted range. The current value is: -18. The permitted range is: from -6 to 2,147,483,641."

I'm getting the same error for every excel that I'm trying to upload.

The callstack is:

The value of Seek/OffsetFromEnd parameter is outside of the permitted range. The current value is: -18. The permitted range is: from -6 to 2,147,483,641.

Internal session ID:
4d22ebf4-293e-49a9-8c61-bcdc8eed8247

Application Insights session ID:
48500fee-de9f-4d7b-97bb-725f0ca6f9be

Client activity id:
352c069e-cedc-4f14-9a03-e44cf353e56e

Time stamp on error:
2023-01-18T16:32:06.7446221Z

AL call stack:
"Excel Buffer"(Table 370).GetSheetsNameListFromStream line 6 - Base Application by Microsoft
"SUIT Import Events"(CodeUnit 50021).SelectSheetsNameStream line 5 - EN10 - Integration ShipIT-ConnectIT by SucceedIT
"SUIT Import Events"(CodeUnit 50021).OnAfterImportProcess line 13 - EN10 - Integration ShipIT-ConnectIT by SucceedIT
"IDYC Import Events"(CodeUnit 11148638).OnAfterImport(Event) line 2 - ConnectIT 365 by IDYN B.V.
"IDYC Import Mgt."(CodeUnit 11148601).Import line 114 - ConnectIT 365 by IDYN B.V.
"IDYC Import Mgt."(CodeUnit 11148601).OnRun(Trigger) line 2 - ConnectIT 365 by IDYN B.V.
"IDYC Import Definition Header"(Table 11148599).Import line 13 - ConnectIT 365 by IDYN B.V.
"IDYC Import Definition Card"(Page 11148601)."Import - OnAction"(Trigger) line 24 - ConnectIT 365 by IDYN B.V.

I debugged it and when trying to Open XlWrkBkReader then is throwing the error (XlWrkBkReader := XlWrkBkReader.Open(FileStream);).

Do you know what could be the cause ?

I have the same question (0)
  • Manthan Thesiya Profile Picture
    59 on at

    Hello Daniel,

    If this customization done by you than check the code which is written for Import function.

    also similar case i found of old version issue check might it help you any.

    "The value of the COPYSTR parameter 2 is outside of the permitted range" error message when you run the Reconciliation function in the Dutch version of Microsoft Dynamics NAV 2009 - Microsoft Support

    If possible than share code for Import function.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,711 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 998 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 635 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans