Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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,112

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,272 Super User 2024 Season 1 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,272 Super User 2024 Season 1 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,162 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,112 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,112 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,112 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,162 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,112 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,162 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans