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\
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.
How to solve it ?
Now or Never