Links update doesnät work every time

[pruleone]

Hy,

I moved some of data out from main workbook. I linked data beatween two workbook simple way for A2=[workbook2]'Sheet1'!A2

Most of links work very good but some links wouldn't update data. I see just #NA.
This error don't change even if I go under edit menu to link menu and update there data.

But all will be work very good after I open that second workbook.


Does someone knows why excel is doing this?
Maybe some idea what must I do to remove this problem?

 

[SkipVought]

You have some work to do.

Check out Correct a #N/A error in HELP.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[pruleone]

I looked excel help and didn't get helpful idea.

Problem is quite funny because after I turned off automatic update between workbook when opening workbook, then I will see all correct data.
But after I choose to update data then I'll get those #N/A values.

Those errors are also strange because they appeare only in few cells. Most of cells have correct data.

 

[SkipVought]

Nothing particular funny.

When Excel tries to resolve the reference, it cannot find it. That's what happens when you UPDATE the link!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[macropod]

Hi pruleone,

Assuming your linkage formulae are all in the simple form of =[workbook2]'Sheet1'!A2, rather than being something more complex, the problem may have something to do with the contents of the source cells. If you look at those, you may find there's a formula Excel is unable to resolve while to source workbook is closed.


Cheers
[MS MVP - Word]

 

[pruleone]

What I tryed was to change source.
I got error message formula is too long.

After I press OK, it appears again and again.

What this kind of message should mean?

 

[pruleone]

So,

I resolved this problem.

What I did - first I moved one sheet, what did make problem form me to third workbook. Secondly - until now I protected my workbook and worksheet. I removed workbook protection and made it work as it has to be.

According that after moveing data to third workbook didn't help me I think that problem was that I had protected my worksbook under tools menu.

At this moment this solutions is ok for me, but to look fovard this solutions is not the best one.


Thank you all.

 

[SkipVought]

There are usually better solutions than linking cells.

I routinely get data out of other workbooks. My data is ALWAYS organized as tables--one table per sheet, headings in row 1 starting in column A.

I use MS Query. faq68-5829

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[pruleone]

This is good solution you mention but to use it I must renew all workbook.

I will keep this solution in my mind and maybe one day I will make all that workbook again.