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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,033 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,105 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,035 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans