Hi All,

I have a problem on Excel 2007 while refreshing (for pivot table) data from SQL Server view:

"Data could not be retrieved from database. Check the database server or contact your database administrator. Make sure that external database is availiable, and then try the operation again"

Excel file is distributed on about 20 workstations in network with the same Excel version, and problem occurs only on one station. I have checked credentials and connection between workstation and server and it seems to be ok.

Any ideas?

Try to login the particular staation as administrator account.

I've tried... effect is the same.

Tried also adding new data connection in excel via Data Connection Wizard and selecting Other/Advanced option insead of Microsoft SQL Server. In that way there's no error, but data is not refreshed.

if we logon a sql, it uses current user account as default. have you add the account to sql of particular station's account?

it is problem, because sql server is not member of domain... so I'm using sql aunthentication.

strange thing is that from any other workstations (aldo in domain) it works fine when providing SQL user. I'm supposing that it is problem with some excel settings