Register
Log In
Unanswered
Home
Excel Analysis Toolpak
October 17, 2015
Offline
Dear All,
I keep running into an issue with PQ privacy settings. When I build my queries I mark appropriate settings and all is well. However, next day my users are trying to work with the files and they keep getting prompted for "information about data privacy" too. Most of my users don't know a thing about PQ and don't care to know. They think that the query is broken.
Is there a way to prevent this privacy issue from happening?
We work in Virtual Desktop environment and I wonder if this have anything to do with the issue. For example, my Formula Bar disappears every day, but I can deal with this. The privacy setting issue is a major annoyance.
Thank you,
Blanka
See Answer
July 16, 2010
Offline
Hi Blanka,
You have two options;
1. Set the query to Fast Combine: https://support.office.com/en-us/article/Privacy-levels-Power-Query-cc3ede4d-359e-4b28-bc72-9bee7900b540?ui=en-US&rs=en-US&ad=US&fromAR=1
There are risks with this.
2. use the technique described here: http://www.excelguru.ca/blog/2.....-settings/
Mynda
Answers Post
Excel Analysis Toolpak
October 17, 2015
Offline
Hi Mynda,
Thank you for your reply.
I did go the Fast Combine route, but the file still asked for the privacy setting.
I may have to try the macro technique, which isn't optimal either because that would require to have all the affected files converted to macro-enabled.
Thank you again.
Blanka
Most Users Ever Online: 57
Currently Online:
16 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:
sugi gunawan
janja mesec
John DiMartino
lizette acosta
eric johnson
Kim Bond
Nichelle Stevens
Manuel Rodriguez
peter wang
Amit Kanekar
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
