$$Excel-Macros$$ Custom views seriously slow down shared xlsm sheets

I had an xlsm workbook that was shared and very slow even though the file size was only 3000 K. This file took around 3 minutes to open or save. After removing the custom views that had been automatically created by users editing the sheet, the file size went down to 200K ... opening now takes 4 se

$$Excel-Macros$$ Unable to open workbooks from custom functions?

I have a custom function that needs to read data from an external worksheet. To make sure that the workbook is open I use the following method: Sub EnsureWorkbookOpen(ByVal fPath As String, ByVal fName As String) On Error Resume Next Err.Clear Workbooks(fName).Activate If Err.Numb