Send to Excel Not Asking for Password

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (8)

Answers (1)

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

RE: Send to Excel Not Asking for Password

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?

Was this reply helpful? Yes No
RockwithNav 8,576 Super User 2025 Season 2 on at

Like (0)

Report

RE: Send to Excel Not Asking for Password

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?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: Send to Excel Not Asking for Password

Is the excel version same (prior and current). I have faced similar issue with Excel version while having NavUserPassword as authentication.

Was this reply helpful? Yes No
Verified answer

Alexander Ermakov 28,096 on at

Like (1)

Report

RE: Send to Excel Not Asking for Password

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Send to Excel Not Asking for Password

Hi Nareshwar,

There are no customizations to Excel and the user clicks the button Send to Excel from within the Windows client.
Regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Send to Excel Not Asking for Password

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!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Send to Excel Not Asking for Password

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Send to Excel Not Asking for Password

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.

Was this reply helpful? Yes No