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.