Register
Log In
Unanswered
Home
Members
Dashboards
Power Query
Power Pivot
Excel for Decision Making
June 2, 2016
Offline
Learning lots on power query and power pivot but the one thing that I am missing is sharing these excel sheets with other dept. For example I created an excel workbook that has a great pivot table using power query that was imported from a private folder. if i copy that excel sheet to a user desktop the excel workbook becomes useless because it can no longer get to the data source yet i don't want the folder to be public for anyone to go in and change or delete files. what am i missing?
November 8, 2013
Offline
Hi Bill,
You have to change the process: Create a file with queries to extract data from that private folder, that you will have to update from time to time, then create a file for users, that will connect to the file that has all the data with no restrictions, not to the private folder.
Most Users Ever Online: 57
Currently Online: Max Neumann
17 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
