priya20sept
New Member
- Joined
- Jul 19, 2011
- Messages
- 1
We have a report in Excel. The report was created using Excel2003. The report is stored at the ftp location. Once we open the report, and click refresh button, the export data is refreshed. It imports data from As400 database. There are several sheets in single Excel. Initially there was Excel2003 installed and everything was working properly. Now we have upgraded to Excel2007 and problem started. When we try to refresh data, it asks for password to database connection. When we were using 2003, it was asking the password only once. But now it asks the password for as many time as many sheets are there in Excel. Is there any way or setting so that the password needs to be entered only once?
