web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    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?

  • subrata.bauri Profile Picture
    subrata.bauri 1,144 on at

    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

    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

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

  • subrata.bauri Profile Picture
    subrata.bauri 1,144 on at

    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

    FYI..

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

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

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

  • DAnny3211 Profile Picture
    DAnny3211 11,397 on at

    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

  • DAnny3211 Profile Picture
    DAnny3211 11,397 on at

    and

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

    1. OperationTimeout : MaxValue

    2. MaxUploadSize : 300MB

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans