DPChristman
New member
- Joined
- Sep 1, 2016
- Messages
- 5
- Reaction score
- 0
- Points
- 0
I have an odd situation.
One of my forms contains a VLOOKUP to a spreadsheet containing employee information.
Enter the employee ID #, and the employee information is automatically populated.
This is repeated about 10 times on the form, so you can enter the employee ID for up to 10 people, and have it populate the data
The spreadsheet that the VLOOKUP pulls from is on a shared network drive.
The problem is a strange one.
Some of my users are reporting that when they enter the employee ID, it populates for the first few employees, then starts giving an #N/A message for the others.
I had them send me the format they were working on. Although they were receiving the #N/A message in the auto-pop fields, everything was populated normally when I opens the form.
Important note, I am not directly connected to the corporate server. I am connecting through a VPN (I work from home), just like they do. yet, I have no problems.
I have examined, and re-examined the formulas, and they all work correctly.
I thought that this may be related to the fact that the users also use an air card to connect to the internet, but I am told this happens whether they are on air card, hard wired or wireless.
All constants are in place, and the format works fine for me. They tell me that they are clicking on Enable Content when they open the file, so that is not the issue.
I am baffled. Any thoughts?
x-posted on mrexcel
One of my forms contains a VLOOKUP to a spreadsheet containing employee information.
Enter the employee ID #, and the employee information is automatically populated.
This is repeated about 10 times on the form, so you can enter the employee ID for up to 10 people, and have it populate the data
The spreadsheet that the VLOOKUP pulls from is on a shared network drive.
The problem is a strange one.
Some of my users are reporting that when they enter the employee ID, it populates for the first few employees, then starts giving an #N/A message for the others.
I had them send me the format they were working on. Although they were receiving the #N/A message in the auto-pop fields, everything was populated normally when I opens the form.
Important note, I am not directly connected to the corporate server. I am connecting through a VPN (I work from home), just like they do. yet, I have no problems.
I have examined, and re-examined the formulas, and they all work correctly.
I thought that this may be related to the fact that the users also use an air card to connect to the internet, but I am told this happens whether they are on air card, hard wired or wireless.
All constants are in place, and the format works fine for me. They tell me that they are clicking on Enable Content when they open the file, so that is not the issue.
I am baffled. Any thoughts?
x-posted on mrexcel