Dropdowns Disappear after Email

[bholbrook]

I have an excel file that uses 3 dropdowns per row, each dynamically populated from one before. Everything works fine on my computer, and any colleagues computer. But when I send it to my client, he cannot use the first dropdown in any row which renders the whole sheet useless...

What I've already done:

• I checked that we're using the same version excel file.
• I checked the view objects in on from the excel options tab
• I've repaired the file
• I've tried multiple exports of the file
• I verified that I'm getting my values from the same workbook (no external sources).

The weird part is that when I am on his computer, I look at the data validation for the cell in question and the Data Validation Source is empty.

Values from Data Validation: Source:

The first one is a simple range:
=Lookups!$K$2:$K$10

The second references a range form the first cell:
=INDIRECT(A3)

The third looks for a list of options for that product:
=OFFSET(Options!$A$1,MATCH(B3,Options!A$1:A$164,0)-1,2,1,COUNTA(OFFSET(Options!$A$1,MATCH(B3,Options!A$1:A$164,0)-1,2,1,20)))

 

[bholbrook]

Bump... (This is an emergency, must go out today, any ideas welcome).

 

[bholbrook]

Bump...