CIVILDESIGNDAN
New Member
- Joined
- Apr 1, 2015
- Messages
- 1
Hi,
I have a data base that I setup to be able to create multiple other sheets and pull the same information from sheet to sheet. The issue I am having is that the formula for the data validation drop list keeps updating back to the current sheet that the drop list is in instead of keeping the main data base tab name. This is a spreadsheet that multiple people are working in, as well as other things going on such as copy and paste of rows to keep other forumlas the same. It seems to happen after I save the spreadsheet and get out of it and come back in, I have tried recreating the error to see if it is the copying and pasting of the rows, tried protecting the entire sheet from formatting changes, and am at a loss as to the origin of this issue.
Any help would be useful. Need more infromation let me know.
Thanks,
I have a data base that I setup to be able to create multiple other sheets and pull the same information from sheet to sheet. The issue I am having is that the formula for the data validation drop list keeps updating back to the current sheet that the drop list is in instead of keeping the main data base tab name. This is a spreadsheet that multiple people are working in, as well as other things going on such as copy and paste of rows to keep other forumlas the same. It seems to happen after I save the spreadsheet and get out of it and come back in, I have tried recreating the error to see if it is the copying and pasting of the rows, tried protecting the entire sheet from formatting changes, and am at a loss as to the origin of this issue.
Any help would be useful. Need more infromation let me know.
Thanks,
