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]

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:

 

[Fazza]

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]

Thanks for your help.
Solution was to set connection privacy to ignore everything.
Now it is working