large files

Hey all, First time posting here. I think i've done a pretty good job at searching and scouring previous posts to make sure this problem is an original one; however, if you know of relevant post to this that i missed, please let me know. I'm using Excel 2011 for Mac. I'm working with a...

Hi, I have multiple workbooks open and one of them is quite a large file with a huge amount of calculations in it. I have copied values as much as I can in the file, but the rest of the calculations are needed for choices I make as the data is dynamic. The problem/question I have is: When I...

Hi, I hired a programmer to have a desktop application to extract data from a website containing 160.000 rows and 20 columns. The programmer can download the entire 160.000 items in one single file. I can't manage to do it and it crashes at the end of the data extraction when it is time to save...

Dear All, I have developed an algorithm that manipulates a large number of considerably large Excel files (please refer to the summary at the end). When I work with few files only, I have no problem with any computer. When I increase the number of files, however, the process doesn't work with...

I'm in the finance industry, and I need some advice. I have 100gigs of raw historical option price data in .csv format. It's essentially 10 years worth of daily closing prices for every single option traded in North America. When I got the data, each .csv file contained a single day's...