Spreadsheets keep prompting for password over and over again


Click on Start, Programs, IBM i Access for Windows, System i Navigator

 

Right click on the left hand side on the “connection name”

Choose properties

 

Click connection

 

Remove the “prompt every time” radio button and select the “use default userid, prompt as needed” radio button. Put your AS400 userid in.

Click ok

Click ok again on this message

 

Your spreadsheets will refresh with only one userid/password prompt now.