All of our users are on Excel 2003 on Windows XP SP2 machines.
One of them has a 100Mb file that he uses to perform calculations on using complex formulae. Info from this is then picked up by other Excel files.
Recently, his computer has been throwing up errors stating that it doesn't have the system resources to either keep the file open, or make a change to it - the exact message is: "Excel cannot complete this task with the available resources. Choose less data or close other applications". He generally then opens a new Excel file. When he sends the mail out, he also notices corruption and external users are unable to open it.
Does anyone know what the maximum recommended Excel size is?
Also, could the sequence of events I've described result in corruption of the file?
Urgent, so max points!