i receive and error message stating " excel cannot complete this task with
available resources. choose less data or close other applications"
my computer has windows 2000 professional with office 2003 installed on it.
the config. of the m/c is P IV 2.8ghz 512 RAM and 40 GB HDD . I am working
in excel 2003 and have used up majority of the columns.each column calculates
a value using a formulae.the calculations go on in a chronological
manner.they r also interlinked.
my file size is 6.72 MB .
i am developing this pricing system in excel in where i have two sheets
which inputs data and other 3 sheets use this data and do calculations.i had
searched the microsoft knowledge base earlier but did not getany relevant
solution to my problem.
prior to this i would recieve another error message stating that " not
enough system resources to display completely" . i still recieve this
message. this message occurs whenever i am trying to key in data or
performing a calculations.
Please provide me with a solution.