banner_ad

How to open 2 excel files size of 40MB each

Excel for Finance 1472 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
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
27 May 2026
Audit Assitant

Virender K Gupta and Co

New Delhi

B.Com

View Details
Company
Featured 26 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
ARTICLESHIP 27 May 2026
CA Article Trainee

Rahul Dang & Associates-Chartered Accountants

Pune

CA Inter

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 08 June 2026
Internal & Taxation Article

O P Bagla & Co LLP

New Delhi

CA Inter

View Details
Company
04 June 2026
Semi Qualified CA

Goyal Puneet & Associates

New Delhi

CA Final

View Details
Company
19 May 2026
Fundraising Expert

MentorsWorld Ventures Private Limited

Ahmedabad

Others

View Details