I've created a workbook and added some data queries and when I open it from another computer I've got Initialization of the data source failed.

MGadAllah

Board Regular
Joined
Apr 13, 2008
Messages
59
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
Hi,
I've the following problem and I do hope to find any solution.
Here is the exact situation from the beginning:
- I've created a workbook as a data entry file, this file has 5 sheets and each sheet includes some similar and some different tables headers.
- This worksheet is shared between 2 users on the same network.
- I've created some name ranges inside the data entry workbook.
- I've created another workbook, and it is a clean and an empty workbook, so the 1st thing I did was adding a new query from another file (I mean the previously mentioned workbook as a data entry file) and added several others queries the same way.
- After adding, combined, and appending several queries, I've created a big query that includes everything I need.
- Then I've added a pivot table to this workbook, and used the big query that includes everything I need as a data source.
- I've finished everything I need to do or have within this PivotTable and everything worked as fine.
Now the problem is that, when I open this workbook (The one that includes the PivotTable, and this PivotTable has the big query as a data source) from another computer -which is important as this file used by several colleagues as a summarized reports- I've got several errors and nothing could be refreshed or updated.
Please help.
Thanks :)
Here are the screen I've got:
1.png

2.png

3.png
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
hello

I don't know what the problem is. Maybe to do with working across a network, or the sharing of files.

Basically, you're making a pivot table from some source data. If that can be done from your computer, then suggest you check if it can be done from the computers of your colleagues. That is, created from scratch at their computers. If this works you could just stop there: they have a pivot table that works, and each time they just refresh everything to have the current information. Next level up, suggest you create VBA to do the same thing: maybe best saved as an add-in file because if changes are needed at some time, the add-in can be updated & re-issued.

If the sharing of the network data file is an issue - causing it to not to be queryable - then add some code to that file so that it creates a separate, stand-alone copy. Such as in a dedicated sub-directory. This file exists purely so that queries can run against it. The users continue to share the network file as currently, and this other file is a separate copy only for your querying. OK?

Hope that helps.
 

MGadAllah

Board Regular
Joined
Apr 13, 2008
Messages
59
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
Thanks for your help.
Solution was to set connection privacy to ignore everything.
Now it is working :)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,328
Messages
5,547,278
Members
410,783
Latest member
sonnny
Top