Performance issues in Excel 2016 after resent Update
I've had a few apparent issues after the resent update to Windows and Office 365. I have a Workbook with several worksheets that use VBA and Userforms to to collect and organize data. One issue was with VLOOKUP. When is would attempt to copy the formula to another sell the formula would update to the next row of information, but the value in the cell would remain unchanged. I learned from the Community that there are setting that can affect this and there was. This setting was apparently changed during the update process for everything was working find before hand. Now I discover that the VBA Userforms are running SUPPER SLOWWWW :-(. They perform the task to completion, but data-entry is pointless. Anyone else experiencing anything similar?