sunshinereel2
New Member
- Joined
- Jul 21, 2016
- Messages
- 9
Good Morning;
I have an excel sheet(A) that has a vlookup formula and includes a link to another excel sheet(B) that others in the office update so that I have up to date information. Lately(since a new hire began) when I open my document(A) with the external links to (B) and I have another excel sheet that has nothing to do with the other two(actually my time sheet)(C) the vlookup populates from that third sheet even though the links clearly indicate the other document(B).
Files A & B are located in the same drive on the server and file C is located in my drive on the server.
Any thoughts or help would be greatly appreciated. I have checked the Edit Links box and the time sheet file name is not listed. The first time I thought just a glitch but it is occurring on a weekly basis now and I wonder if it has to do with something the new hire is saving it as? However, she does not have access to my drive to accidently link it to my time sheet.
I have an excel sheet(A) that has a vlookup formula and includes a link to another excel sheet(B) that others in the office update so that I have up to date information. Lately(since a new hire began) when I open my document(A) with the external links to (B) and I have another excel sheet that has nothing to do with the other two(actually my time sheet)(C) the vlookup populates from that third sheet even though the links clearly indicate the other document(B).
Files A & B are located in the same drive on the server and file C is located in my drive on the server.
Any thoughts or help would be greatly appreciated. I have checked the Edit Links box and the time sheet file name is not listed. The first time I thought just a glitch but it is occurring on a weekly basis now and I wonder if it has to do with something the new hire is saving it as? However, she does not have access to my drive to accidently link it to my time sheet.