Related Posts
Thoughts on homage watches?
Does the company provide fringe benefits?
Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.




Depending on what you’re doing maybe you can leverage SQL
Could you ask your corporate IT department for help with this?
Check your add-ons, maybe disable a few
Maybe it isn’t Excel but what you’re doing in Excel. Can you describe what kind of tasks you are performing.
I’d recommend using MS Access or some other kind of SQL DB.
If you are experiencing latency issues, you are using the wrong tool. Even if you say “I’m just doing pivot tables!” If you’re working with data pushing the threshold of excel’s limits… go do your task in SQL, Python, any other tool that doesn’t have these limitations.
Excel has these limitations because at a certain point, what are you doing
I’ll add, every tool has limitations. This is one of excels. Too many rows/columns? Use another tool.
I tell this to people who run into your issue in Python, and there’s an answer there too, use Pyspark. It’s not a you thing. It’s a tool thing.
11mb is not that large of a file. There may be an issue with add-ins or something being done in the file.
As an alternative, I often use Python and pandas dataframes for data extraction and transformation from Excel files. It works well for single person or small team processes. However, larger team deployments can be challenging.
If you utilize a lot of X/V/H Lookup functions/formulas in the files consider the use of SUMIF or SUMIFS. The lag or delay Lookup formulas cause when used excessively could present as being network issues.