I have a very strange problem. Lets say I have 3 sheets which consist same format to fill with different specification. Per sheet I have several type of cells based on the validity, some cells can have all value, some come from the list and last one (this is where the fun begin) is Cell Range. for context I only have same page reference for the Source of these Cell Range.
The sheet currently works perfectly fine for my needs, but sometimes when I need to add some set of data (multiple sheets) I copy-paste the file I lastly worked in and then delete or add the sheets (copy sheet) based on how many sets of data are needed at that time. Problem occurs when I want to delete the last sheet, suddenly the cells in other sheets with Cell Range format suddenly only display #REF!.
Any logical explanation on why this could be happening? and what is the solution?
Lately I discover this only happen if I am working with .xlsx file, no problem in .ods file. But converting existing .xlsx file to .ods using Save As function, will have no affect whatsoever (problem still occurs) which is the case on my condition right now.
I attach the .xlsx and .ods file for example on how to replicate my case, Thanks.
[LeroyG deleted duplicated content here]
trial validity select.ods (15.5 KB)
trial validity select.xlsx (8.6 KB)
