You’re offline. This is a read only version of the page.
Dear NAV Community,
Our customer uses the Send to Excel feature to export data to a spreadsheet. Previously the user was required to input a user name and password whenever accessing the data in the spreadsheet. Now there is no password when the user tries to access spreadsheet. My question is... is this normal behavior? Does anyone know why previously the system asked for user name and password but now it doesn't.
Background info: we just upgraded the customer to NAV 2016 from NAV 2015 (a few months ago). The user uses NavUserPassword authentication.
Thank you if you can solve this one!
*This post is locked for comments
If not asking for a password is the normal behavior of the software, then I would say that my problem is solved. Actually the user liked having it ask for a user name and password just because she assumed that is the normal system behavior and now the system is not behaving correctly (it may have given her a sense of added security). It is true that she is not part of the domain structure when she was logging in.
I am not sure whether Excel version was same (probably was Excel 2016 both before and after the upgrade). Actually the strange thing is that the Send to Excel feature was working perfectly for several weeks after the upgrade and then it stopped working (it wouldn't even send entries) on the PC of the finance manager. I told her to run the setup program and repair and then Send to Excel started working again but it wouldn't prompt for password. I just tested it on a different workstation (Windows client) and it prompted for NAV user name and password before opening the exported data the first time. After saving the Excel file, it does not prompt for a user name and password to open it again.
Hi RockWith NAV,
You are correct in your understanding. Previously when users (or at least one user, the Finance Manager who submitting the issue to us) clicked Send to Excel it would ask for a password. She even told me that if she saved it to her computer it would ask for user name and password the next time she opened the file.
Regards!
Basically, the more correct behavior is when the password is NOT asked each time when you export to Excel. So, the question is rather "why previously it asked for the password". Mainly, it is quite annoying to enter the password all the time you export something, isn't it? It can depend on the network settings for particular users. I had seen such cases when the users used Windows client installed on their laptops and the users were not the part of the domain structure.
Is the excel version same (prior and current). I have faced similar issue with Excel version while having NavUserPassword as authentication.
Hey Theodre,
What I Understood is earlier when users export it to excel from NAV then it Prompts for password from excel side but currently it's not. Is this the Case?
Hi,
To be more clear, the user opened the Excel to view the data right? So then, the prompt came up right?
Is there any customizations done on the Excel side?
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,113
Super User 2024 Season 2
#2
Martin Dráb
229,918
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (