I have excel forms using dynamically named ranges and data validation. These forms all point to one workbook containing master lists. Using the example name below everything works great with one caveat.
=OFFSET([DocEntry_MasterList.xls]keywords!$F$2,0,0,COUNTA([DocEntry_MasterList.xls]keywords!$F:$F),1)
I have one user who saves changes to the the forms and every single time the named range changes to the following:
=OFFSET('E:[DocEntry_MasterList.xls]keywords'!$$2,0,0,COUNTA('E:[DocEntry_MasterList.xls]keywords'!$F:$F),1)
This does not happen with any other user. I can mimic this problem by saving the forms and master list to another directory and the named range changes in a similar way.
Thanks for any suggestions.
Jennifer
=OFFSET([DocEntry_MasterList.xls]keywords!$F$2,0,0,COUNTA([DocEntry_MasterList.xls]keywords!$F:$F),1)
I have one user who saves changes to the the forms and every single time the named range changes to the following:
=OFFSET('E:[DocEntry_MasterList.xls]keywords'!$$2,0,0,COUNTA('E:[DocEntry_MasterList.xls]keywords'!$F:$F),1)
This does not happen with any other user. I can mimic this problem by saving the forms and master list to another directory and the named range changes in a similar way.
Thanks for any suggestions.
Jennifer