If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Defined name changes on save

Thread starter Jeffifer
Start date Oct 2, 2002

Jeffifer

New Member

Oct 2, 2002

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