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
Bookmarks