May 11 2021 02:10 PM - edited May 27 2021 05:46 AM
I have been using Excel for over 25+ years and consider myself an expert. Excel cannot handle complex formulas and big data. Even without volatile formulas Excel can't handle much of anything you throw at it. As I type I sit and wait for now 12 mins because Excel is frozen. And why... because I deleted a column from a table. Holy crap. Make sure you don't ever paste from a FILTERED table into another sheet by accident either or you'll be waiting while Excel re-calculates each and every cell it pastes. Uggghhh FOREVER. Today went into a file to process a macro via VBA and I see the code in the project folder but when I clicked on my code would not show up in the window. Just a blank page where my career will one day be thanks to Excel. I had to open Excel as Safe Mode save the file and re-open it. Tables always seem to cause more headaches then they are worth. Excel has way too many flaws. We need better programmers working at Microsoft. Please someone make Excel better. I deal with this stuff DAILY.
May 11 2021 03:05 PM
You mention big data and filtering; that sounds database oriented in which case are you using Power Query and Power Pivot which were designed for that purpose? Could you actually move the data to a database? As you suggest, going beyond the point at which the workbook collapses under the weight of data is not going to be a rewarding experience.
May 11 2021 09:36 PM
May 12 2021 04:43 PM
May 13 2021 11:10 AM
May 13 2021 11:22 AM
May 13 2021 12:30 PM - edited May 13 2021 12:41 PM
is your code modular? See example below and maybe create error handling routine/subroutine/sub procedure
Main Procedure - Visual Basic | Microsoft Docs
Module mainModule
Function Main() As Integer
MsgBox("The Main procedure is starting the application.")
Dim returnValue As Integer = 0
' Insert call to appropriate starting place in your code.
' On return, assign appropriate value to returnValue.
' 0 usually means successful completion.
MsgBox("The application is terminating with error level " &
CStr(returnValue) & ".")
Return returnValue
End Function
End Module
OtherFunction(
Other Function Statements or Expressions...
)
Other Sub(
Other Sub Lines...
Exit Sub
)
May 14 2021 07:05 AM
May 27 2021 06:03 AM