Hi,

I have a large excel file using Byrow with unique, filter & sumifs functions to extract data.

Before, I just press F2 and Enter to return the spill array.

Recently, It does now show the first item of spill array.

I need to press Shift-F9 or F9 to show the fill spill array.

This takes too much time.

This happended after the recent update.

USING: EXCEL 365 LATEST VERSION

​Hi, I have a large excel file using Byrow with unique, filter & sumifs functions to extract data.Before, I just press F2 and Enter to return the spill array.Recently, It does now show the first item of spill array.I need to press Shift-F9 or F9 to show the fill spill array.This takes too much time.This happended after the recent update. USING: EXCEL 365 LATEST VERSION  Read More

​