How can I remove a password that was copied to a new workbook?

I

ISU4EVER

I copied a file that was saved as FY08 and was password protected. I want to
call this file FY09 and have it password protected. My problem is when I open
file FY09 I have to enter the password for FY08 and then for FY09 before it
will let me open the workbook for use.

How can I get rid of needing to enter the password for FY08 and only have to
enter the FY09 password.
 
D

Dave Peterson

I'm guessing that you have a link back to the FY08 workbook. And when excel
tries to refresh that formula/link, it needs to know the password so that it can
get the value.

I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm
to find that link.

But I'm not sure what you're going to do next.

Do you point the link at a cell in the FY09 workbook? Do you convert the
formula to values????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word 97 Password 0
Password protect new workbooks from template 0
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Pivot Table help 0
I have lost 6 months work, how can i get my file back 1
Pop up requires me to confirm password to allow email to be received 0
IF Function with Dates 9
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0

Top