excel "sheet name" which linked becames #ref when closed and reopen

[ndiaye]

Hi all,

I have a problem. For an example:

• We have two excel files. A & B.
• They have two different workbooks inside.

B / Sheet 1 /A1 =20

B / Sheet 1 /A1 cell link to A /Sheet 1/A1.

So the A /Sheet 1/A1. cell inside like this:
'B/ Sheet 1/A1
So the result show is as to be which means 20.

It is ok up to here. I save and close the both and re-open.

A/ Sheet 1/A1 look like this:
'B/ #REF/A1

Only problem is:
It changes the excel sheet name as #REF.

Before submit a reply, we applied these:

• No hided sheet exist on both excel.
• Trusted location settings checked, working clearly.
• We also tried to insert new sheet but we reached nothing.

Thanks from now.
Caglar

[Pepe Le Mokko]

When you say " 2 files" I suppose you mean two " workbooks"?

[ndiaye]

I mean Two different excel files. Also, Updated the post.