Links to cells in password protected workbook

October 30, 2017 at 09:39:54
Specs: Windows 10
I'm having a similar situation now ... and Braincapers' result helped me, but now it asks for the user to update the destination file with this information and asks for the password. I'm in Excel 2016.

See More: Links to cells in password protected workbook

Reply ↓  Report •

#1
October 30, 2017 at 09:43:25
Are we meant to guess what the ‘similar situation’ is?

Either explain it here clarly and in detail or provide a link.


Reply ↓  Report •

#2
October 30, 2017 at 09:50:21
Try this:

Make believe that you are one of us, sitting out here on the ole' Interweb.
Make believe that you can't see your workbook from where you are sitting.

Now go back and read your post. If you were one of us, would you have any idea what you are talking about?

If you are referring to a previously closed thread in this forum, then please provide:

1 - A link to that thread, and
2 - A more detailed description of the current issue that you are experiencing

There are hundreds of questions asked and answered in this forum and there is no way for us to keep track of them in our head. Help us help you.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Reply ↓  Report •

#3
October 30, 2017 at 10:00:50
Sorry, replied to another (probably closed) string ... but it showed up here.

I have a password protected Excel file.
I have several "destination" files that pull data from specific cells on that original file.
Problem: In the destination files, I am able to get a macro to open the password protected file, but it still asks the user to input the password to update the destination file from the original file. This is the part I need to bypass, because those using the destination files do not have the password or access to the original file.

As I said, I am in Excel 2016. I appreciate any guidance.


Reply ↓  Report •

Related Solutions

#4
October 30, 2017 at 10:23:27
This is the message received in the destination file. It is opened as Read-Only.
"This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data. Otherwise, you can keep working with the data you have."

All files are on our office server.
Thanks in advance for your help!


Reply ↓  Report •

#5
October 30, 2017 at 10:23:29
re: "I have a password protected Excel file."

What is your definition of "password protected"?

Password Protected so that a user needs a password to open it, or Password Protected so that a user needs a password to change the data within it or both?

Since you seem to be able to open it, you either don't have it Password Protected against opening or you have dealt with that level of protection within the macro. Please clarify what type of protection you are using.

In your OP you said "and Braincapers' result helped me". Helped you do what?

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#6
October 30, 2017 at 10:26:00
The original/source file is password protected so that a user needs a password to open it.

In your OP you said "and Braincapers' result helped me". Helped you do what? - Create the macro that opens the source/original password protected file.


Reply ↓  Report •

#7
October 30, 2017 at 10:27:25
Wait. I'm confused.

First you said "it still asks the user to input the password to update the destination file from the original file."

Now you've said "This is the message received in the destination file. It is opened as Read-Only.
"This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data. Otherwise, you can keep working with the data you have."

Which is it or is it both?

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#8
October 30, 2017 at 10:44:48
That is the message prompting user to update (or not). If user clicks update, it prompts them for the password to the original/source file - which they don't have access to.

Reply ↓  Report •

#9
October 30, 2017 at 11:02:12
I have tried this, but it did not help:

Don't prompt for all workbooks I open, and update the links automatically

This option affects every workbook opened on the computer. Users who open the workbook on another computer are not affected.

Click the File tab, click Options, and then click the Advanced category.

In Excel 2007, click the Microsoft Office Button Office button image , click Excel Options, and then click the Advanced category.

Under General, clear the Ask to update automatic links check box. If this check box is cleared, the links are automatically updated, and no alert is displayed.


Reply ↓  Report •

#10
October 30, 2017 at 11:12:24
The thread in following link discusses a possible work around for your issue. It's the 2nd response from "JLLatham" that I am referring to.

In essence, instead of linking the destination workbooks to an external workbook, you link the destination workbook to "itself" after you copy the required data from the source workbook into a sheet in the destination workbook via the macro that JLLatham provides.

You could hide the "destination sheet" in the destination workbook via the VBA Very Hidden property so that the user doesn't even know that the extra sheet is there. (I assume that your VBA code is password protected and Locked For Viewing so that the users can't access it)

I've never tried this technique, but it sounds reasonable. Setting up an environment similar to yours with multiple workbooks, links to external password protected files, macros etc. can be cumbersome and there's no guarantee that I would be duplicating what you have enough for any tests to be valid. Take a look at this and let me know if it helps:

https://answers.microsoft.com/en-us...

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#11
October 30, 2017 at 14:07:31
Thanks, DerbyDad03!
That got me MUCH closer. It is automatically updating when opened now, but still asking the user for the password, which essentially does nothing since it is updated.

Reply ↓  Report •

Ask Question