I have an excel file, let's call it A, that is linked to other source
files (say B). The worksheets in this file A are individually
protected. The problem I am having is everytime data in the source
file (B) changes file A is not authomatically updated. To update I
have to open file B the same time as file A. Is there not any better
way to link the 2 files so that update is authomatic? Or could this be
down to the fact that file A has protected worksheets??.

Please help.

Maybe you have calculation set to manual? Tools|options|Calculation tab.

Or maybe you didn't answer the prompt (or didn't get a prompt) to update the
links when you opened fileA.

Edit|links|update values

You may want to find out the reason you're not getting the startup prompt (if
you aren't).

Edit|links|startup prompt
may help.

Ola2B wrote:

I have an excel file, let's call it A, that is linked to other source
files (say B). The worksheets in this file A are individually
protected. The problem I am having is everytime data in the source
file (B) changes file A is not authomatically updated. To update I
have to open file B the same time as file A. Is there not any better
way to link the 2 files so that update is authomatic? Or could this be
down to the fact that file A has protected worksheets??.

Please help.

--

Dave Peterson

On 9 Aug, 15:57, Ola2B wrote:
I have an excel file, let's call it A, that is linked to other source
files (say B). The worksheets in this file A are individually
protected. The problem I am having is everytime data in the source
file (B) changes file A is not authomatically updated. To update I
have to open file B the same time as file A. Is there not any better
way to link the 2 files so that update is authomatic? Or could this be
down to the fact that file A has protected worksheets??.

Please help.

it dosnt show the prompt to update. and when i check on the link on
the edit/link update, everything seems greyed out as if it had
updated. could it be because the worksheets are protected?

What happens if you unprotect the worksheets in the A workbook?
Do it and I am sure everything will be OK.

Tim


"Ola2B" wrote:

I have an excel file, let's call it A, that is linked to other source
files (say B). The worksheets in this file A are individually
protected. The problem I am having is everytime data in the source
file (B) changes file A is not authomatically updated. To update I
have to open file B the same time as file A. Is there not any better
way to link the 2 files so that update is authomatic? Or could this be
down to the fact that file A has protected worksheets??.

Please help.

Hi,

Do the following in the source document:

1. On the Tools menu, click Options. The Options dislog box is displayed.
2. Click the Calculation tab.
3. Under Calculation, verify that the Automatic option is selected. If this
option is manual, then you have to press the F9 key refresh the display value
in the target file.
4. Under Workbook Options, select the Update remote references and Save
Externel link value check boxes.
4. Click OK to accept the setting.

Note: Now any value you use in the target file, using paste Special caommand
from the Edit menu, will automatically get refreshed. The stored value and
the display value will synchronize automatically.

Challa Prabhu


"Ola2B" wrote:

I have an excel file, let's call it A, that is linked to other source
files (say B). The worksheets in this file A are individually
protected. The problem I am having is everytime data in the source
file (B) changes file A is not authomatically updated. To update I
have to open file B the same time as file A. Is there not any better
way to link the 2 files so that update is authomatic? Or could this be
down to the fact that file A has protected worksheets??.

Please help.