Big Data Analytics (Excel crashes)

[jlugo]

Hi,

I've noticed tons of challenges manipulating big excel files. I'm having challenges dragging down formulas, copying/pasting data etc. because it's too much for Excel to compute.

Would moving the spread sheet to MS Access make a difference in smoothing out these challenges?

 

[jduley]

If you can link/import the data into Access you can perform many of the same formulas although the language is a little different. From there you can export the data back to excel or in excel select Data - From Access and import your access query into a Table or PivotTable.