New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Editing links- changing source on protected wookbooks--HELP?

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Editing links- changing source on protected wookbooks--HELP?

Postby alyssamt1027 » Wed Jun 22, 2016 2:51 pm

I have a rather large workbook that I have to update and archive every 90 days. Within my workbooks there are 50-200 tabs that are all password protected, as this is a shared workbook. I am having an issue with my links this time around. After choosing the new source to link my workbook to it usually has me put in the password for each individual tab within my workbook and once I have done this, it will tell me the source is OK and off I go, but this time around it just continuously asks for the password even after I have gotten to all of the tabs. I am not sure what to do, I spent my entire day putting passwords in and it still isn't correct. HELP ANYONE? :shock: :shock: :shock:
  • 0

alyssamt1027
Rookie
 
Posts: 2
Joined: Jun 22, 2016
Reputation: 0
Excel Version: 2010

Re: Editing links- changing source on protected wookbooks--HELP?

Postby candybg » Thu Jun 23, 2016 8:39 am

One possible issue might be a key stuck on your keyboard. Swap keyboards with a co-worker and see if it will work.

Also, try editing one sheet and see if the password types correctly and allows you access, without updating your data source.
  • 0

candybg
Rookie
 
Posts: 2
Joined: May 18, 2016
Reputation: 0
Excel Version: 2010; 2013

Re: Editing links- changing source on protected wookbooks--HELP?

Postby alyssamt1027 » Fri Jun 24, 2016 3:55 pm

I will try that-Thanks so much :-)
  • 0

alyssamt1027
Rookie
 
Posts: 2
Joined: Jun 22, 2016
Reputation: 0
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 53 guests