Quote:
Originally Posted by 14spar15
Should I be able to add data in column A and in column B right click and refresh?
|
Yes.
Quote:
Originally Posted by 14spar15
When I do this I get an error that says “Initialization of data source failed. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. You see this message again a, create a new data source to correct the database.” I have tried to research this but I can’t figure this out. I am using Excel 2010 if that matters. Thanks
|
If I'm right that you don't have some version of Power Query (it's an add-in 2010/2013 but built-in in later versions under the
Get & Transform section of the
Data tab of the ribbon) installed then have a look at these pages:
How To Install Power Query in Excel 2010 | MyExcelOnline
How To Install Power Query in Excel 2010 | MyExcelOnline
Download Microsoft Power Query for Excel from Official Microsoft Download Center
Download Microsoft Power Query for Excel from Official Microsoft Download Center
It seems you either need Excel 2010 Professional Plus with Software Assurance (whatever that is) or to upgrade your Excel. However the following site seems to say that Power Query will work in other versions of Excel albeit not officially supported:
Power Query Version Compatibility and Installation
https://www.myonlinetraininghub.com/...d-installation