banner_ad

How to open 2 excel files size of 40MB each

Excel 1446 views 5 replies

I am trying to open 2 excel files containing 15 worksheets and only formulaes and links within the 15 sheets. Bu while opening two files of same size and same formulaes and links the second file couldn't opened.

Please help me on this.

Sunil

 

 

Replies (5)

Please change the names of both the files.And try opening it again. I hope it will help.

Dear friend the name of both the files are different but the second file is creating problem because of  its size.

if file size is very huge then sometime it creates problem, check your RAM and upgrade it to 2GB atleaset!

 EXCEL HAS NOTHING TO DO WITH RAM. EXCEL USES ITS OWN INTERNAL MEMORY. ONLY OPTION IN MY OPINION IS TO UPGRADE OFFICE TO XP OR 2007

 

Dear Pariksh*t

To open some file Excel use system memory (i.e. RAM) if the RAM of sys is not enough then it will create problem. I m using excel 2003 & i can open 3 or 4 files at a time having file size more than 40mb(per file). Its totally depend upon your sys.

 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured ARTICLESHIP 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details