Using Excel 365, I built a spreadsheet that included the UNIQUE function for the first time last night. It saved with no problem, but when i opened it this morning, the spreadsheet would only hang with a Calculation Error that never got past 0%. I closed down and rebooted, and the spreadsheet then opened with the "Repaired" tag. Upon investigation, I found the UNIQUE function, which formerly had the format "=UNIQUE(S9:S1342)" had been replaced with an array formula "{=UNIQUE(S9:S1342)}". The formula had been pasted into every cell that had a value (as opposed to the formula being in the top cell only and filling in cells below with values). Finally, all the the formatting in the spreadsheet had been reset to defaults, and all of the charts in the spreadsheet were gone - I assume part of the "Repair" process.
Has anyone else had problems with stability of this function? Any fixes? Thanks!
