You’re offline. This is a read only version of the page.
1,112
Dear All,
An Enduser is facing the below error message during execution of Export To Excel Report in NAV 2016.
Microsoft Dynamics NAV
---------------------------
A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookWriter.Create failed with this message: Could not find a part of the path
'C:\ProgramData\Microsoft\Microsoft Dynamics NAV\90\Server\MicrosoftDynamicsNavServer$DynamicsNAV90\
users\default\Woods\TEMP\__TEMP__589ed7d71b1c4d29b30f4815e1a78ac2.tmp.xlsx'.
---------------------------
OK
---------------------------
How to solve it ?
*This post is locked for comments
The problem has been solved.
The problem was in the Excel Buffer Table.
Now Every Users are able to execute as per last information received from the client Site.
Thanks to everybody for their Time.
Hi Zaid,
I'm not referring anything anywhere in the reports which are built on Excel Buffer table. Few clients are able to execute & few does not.
Hi,
The reason could be, you are referring to the temp path at server. Use the client temp path instead.
Thanks for your reply.
All dot net variables have RunOnClient property = yes in Excel Buffer Table.
But when Users are trying to execute the export to excel report built on Excel Buffer, the generated excel file is trying to find the path in the NAV Server instead of Local Temp path.
Facing the same problem while executing base Report called "Trial Balance", Report ID : 6.
Is it a custom export or the standard one? It seems that NAV is searching for a temporary file at Server side.NAV code is executed at Server side, so if you create a temporary file on the client you’ve to upload to the server.
I'm not using dotnet variables, using Excel Buffer.
NavUserPassword Credential is used in the NAV Instance. RemoteUser are not to able execute the report.
1. Check that your dotnet variables has RunOnClient property = yes
2. Check that your user has an access to Microsoft Dynamics NAV folder
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (