Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Excel Export Error: St...
Microsoft Dynamics NAV (Archived)

Excel Export Error: Store must be open for this operation

(0) ShareShare
ReportReport
Posted on by subrata.bauri 1,144

Dear Sir,

The following error message occurs during Export to Excel Report. The report is build on Excel Buffer Table.

A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.Workbook Writer.Dispose failed with this message: Store must be open for this operation

As recomended, I have changed the values in OperationTimeout, MaxUploadSize (In Server Level) & MaxNoOfXMLRecordsToSend (In client Level), though it's showing the same error message.

What is the solution ?
Kindly reply.

Thanks,

*This post is locked for comments

  • DAnny3211 Profile Picture
    DAnny3211 9,276 Moderator on at
    RE: Excel Export Error: Store must be open for this operation

    and

    I have checked & found the following..........

    1. OperationTimeout : MaxValue

    2. MaxUploadSize : 300MB

  • DAnny3211 Profile Picture
    DAnny3211 9,276 Moderator on at
    RE: Excel Export Error: Store must be open for this operation

    I have the same mistake on nav 2015 in report 322.

    but only when a report is run by a client installed on a user's computer

    if I launch the report from the server is successful

    help me pls

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at
    RE: Excel Export Error: Store must be open for this operation

    This error is different... here it seems that you have a locked Excel workbook and the system is not able to write on that.

  • subrata.bauri Profile Picture
    subrata.bauri 1,144 on at
    RE: Excel Export Error: Store must be open for this operation

    FYI..

    Two diff. NAV versions (NAV13,NAV16) are installed on Every Client PC

  • subrata.bauri Profile Picture
    subrata.bauri 1,144 on at
    RE: Excel Export Error: Store must be open for this operation

    Message in Event log for the same...............

    Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavClientFileException

SuppressMessage: False

SuppressExceptionCreatedEvent: False

FatalityScope: None

Message: The process cannot access the file 'Book1.xlsx' because it is being used by another process.

StackTrace:

     at Microsoft.Dynamics.Nav.Client.FileExceptionHandler.MapException(Exception exception)

     at Microsoft.Dynamics.Nav.Client.FileExceptionHandler.TryExecuteAndHandleFileException(Action action)

     at Microsoft.Dynamics.Nav.Client.FileExceptionHandler.TryExecuteAndHandleFileException(Action action, Action`1 exceptionHandler)

Source: Microsoft.Dynamics.Nav.Client.UI

HResult: -2146233088

----------------------------------

Type: System.IO.IOException

Message: The process cannot access the file 'Book1.xlsx' because it is being used by another process.

StackTrace:

     at System.IO.Directory.DeleteHelper(String fullPath, String userPath, Boolean recursive, Boolean throwOnTopLevelDirectoryNotFound)

     at System.IO.Directory.Delete(String fullPath, String userPath, Boolean recursive, Boolean checkHost)

     at System.IO.DirectoryInfo.Delete(Boolean recursive)

     at Microsoft.Dynamics.Nav.Client.TempFileManager.<>c__DisplayClass2.<DeleteFolderWithNoPrecaution>b__1()

     at Microsoft.Dynamics.Nav.Client.FileExceptionHandler.TryExecuteAndHandleFileException(Action action)

Source: mscorlib

HResult: -214702486


  • subrata.bauri Profile Picture
    subrata.bauri 1,144 on at
    RE: Excel Export Error: Store must be open for this operation

    Your suspicion is natural. But the Excel Buffer does not export small amount of data.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at
    RE: Excel Export Error: Store must be open for this operation

    Excel Buffer table has limits. I suspect that you're exporting a very large amount of records here.

    Does it work with filtering records before export?

  • subrata.bauri Profile Picture
    subrata.bauri 1,144 on at
    RE: Excel Export Error: Store must be open for this operation

    Dear Stefano Demiliani,

    Thanks for your instant reply.

    I have checked & found the following..........

    1. OperationTimeout : MaxValue

    2. MaxUploadSize : 300MB

    Restarting the NAV Service does not solve the issue.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at
    RE: Excel Export Error: Store must be open for this operation

    Normally this is an error due to buffer size. Have you tryed to go to C:\Program Files\Microsoft Dynamics NAV\<YourNavVersionNumber>\Service  , open CustomSettings file and set the value for OperationTimeout as MaxUploadSize.

    If yes, have you restarted the NAV service?

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans