Excel 2010 'overloading'

Hi all,

I have looked for a solution and attempted to streamline my worksheets and formulas and avoid this happening but the size of my worksheets seems to be taking its toll.

I have split my spreadsheets into separate files to reduce the workload on Excel (but increasing the cut and paste work I have to do) just to be able to get my files to work.

The issue is that I have a piece of scientific equipment that we have put together for my research which generates a great deal of data (approx 20gb of raw text files every 24 hours) - to reduce this data I have made a program which interpolates the data down to create representative files which are far more usable at 50mb-800mb csv's

I open these files and re-save them as excel wookbooks, and copy / paste them into my excel spreadsheets for calculations and use. The issue I have is that if I work on larger ones or attempt to open more than one (which is desirable) I get the message 'excel cannot perform this task with available resources'

I have 8gb Ram on a 64bit system and apparently 58% of this is still free. I am pretty sure this is not a ram issue as I get the same problem on a system with 16gb of ram.

I cannot use VBA to streamline my calculations further in this case as there are restrictions on some of the machines in the institution I work for.


Also is there any easy way (other than copy/paste + recreate all of the names from scratch) to import entire sheets including named ranges from one spreadsheet into another?

Any help would be much appreciated, thank you.



Just to add - I appear to be using Excel 32bit on a 64bit windows 7 system. Thanks again