View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dpksy dpksy is offline
external usenet poster
 
Posts: 1
Default Two big size excel file

Dear Sir/Madam

Currenty I have big problem for my excel file processing.
My computer specific is 2.5Ghz / 1G Ram made by Dell
My excel file is around 70 M size.
(Rows are about 4,2000 and columns are 20)

The reason why it is so big is that it includes some tariff.
In excel file , there is lookup function.

My problem is that whenever I process my excel file especially
running some lookup function, my computer says "Memory is full"

So I don't know how to manage my excel file without interrupting.
Do I have to buy more upgraded PC (for example 3.47 GHz and 1.5G Ram)?

Pls advise me any idea.




--
Kind regards
S.Y Kim