Register
Log In
Unanswered
Home
New Member
Power Pivot
Power Query
Dashboards
Members
Excel
Word
Outlook
December 6, 2016
Offline
I have pulled in several password protected workbooks into power query, if the workbooks are open it works fine. However when they are not I get "DataFormat.Error: External table is not in the expected format." I think this is due to the workbook being password protected. Is there anyway around this, perhaps coding the password within power query.
See Answer
July 16, 2010
Offline
Hi Emma,
Yes, it's the password. The only way around it is to write some VBA that opens the files, enters the password and then refreshes your query.
Given that passwords aren't that secure in Excel anyway (plenty of tools online to crack Excel passwords), I'd be inclined just to remove them and instead, move the files to a secure folder that limited people have access to.
Mynda
Answers Post
Most Users Ever Online: 57
Currently Online: clark shao
15 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:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
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
