Have excel set up to pull some count and sum information from a database view in oracle using ODBC.
In my sheet I want to populate about 10 different fields in one sheet with the single result from different queries.
It works except for one thing. Every time I open the file it asks for the database username and password 10 times.
Is there some way I can store these username and password settings in the excel file so it doesn't have to keep prompting for it.