Office 365 and older excel version

%3CLINGO-SUB%20id%3D%22lingo-sub-1535282%22%20slang%3D%22en-US%22%3EOffice%20365%20and%20older%20excel%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1535282%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20trying%20to%20produce%20a%20sharepoint%2Fexcel-based%20ordering%20system%20for%20my%20work.%26nbsp%3B%20Long%20story%20short%2C%20I%20have%20produced%20and%20run%20the%20spreadsheet%20through%20Office%20365%20but%20some%20of%20the%20potential%20users%20for%20it%20have%20Excel%202013.%26nbsp%3B%20When%20they%20try%20to%20run%20VBA%20code%20that%20does%20a%20powerquery%20sharepoint%20refresh%20they%20get%20an%20error%20message%20%221004%20-%20Initialization%20of%20the%20data%20source%20failed%22.%26nbsp%3B%20Is%20this%20down%20to%20the%20older%20version%20of%20Excel%20that%20they%20are%20running%20and%20is%20there%20any%20way%20to%20work%20around%20this%20while%20maintaining%20functionality%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1535282%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

 

I have been trying to produce a sharepoint/excel-based ordering system for my work.  Long story short, I have produced and run the spreadsheet through Office 365 but some of the potential users for it have Excel 2013.  When they try to run VBA code that does a powerquery sharepoint refresh they get an error message "1004 - Initialization of the data source failed".  Is this down to the older version of Excel that they are running and is there any way to work around this while maintaining functionality?

 

Thank you in advance!

0 Replies