Re: ACS password prompt in Excel

Adam, not sure it would help, but the CWBLOGON allows for caching(or removing) logon information in the windows cache.

<snip>
cwblogon

IBM i Access Client Solutions
Version 1 Release 1 Level 0
Logon Utility
(C) Copyright IBM Corporation and Others 1984, 2010. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corp.
Licensed Materials - Property of IBM

To add entries to the IBM i Access for Windows cache:
</snip>


DRIVER Adam wrote on 8/9/2018 11:28 AM:

Hi,

We have users with some huge spreadsheets pulling data from our PROD system. They have several hundred individual MS queries defined within them, no DSN set up, so Excel is handling the connection.

With IBM i Access for Windows, setting the Default profile and prompt once for each system meant it only prompted once when they did refresh all data. With ACS it prompts for each query within the spreadsheet, even with the same setting. IBM are no help, they say it's Excel, which I agree with, except it doesn't explain the difference between the different products.

Tested on both Windows 7 and Windows 10 BTW, same result.

Before we go and tell them they have to rewrite their spreadsheets, has anyone come across this?

Thanks

Adam DRIVER