Cannot open Excel File (too big)

G

Guest

Excel File is about 46MB in size and I'm trying to open it to cut it into smaller files. I don't know if the file size is the issue, and right now I'm not worried about shrinking this files, but I want to open them to begin with.

I have windows 2000 and Office 2000. My machine is a PIV 1.6Ghz with 896 MB of RAM. I would think that it would open with this system, but it doesn't, please let me know if you've got any suggestions.

J
 
G

Guest

Try opening the excel file in Access. There are no limitation there. Then you can either query or break apart the file into the smaller pieces. Remember to name the main file the "master" table then you can call the smaller pieces "table 1 or 4" or whatever you would like.
 
G

Guest

I did that and it worked . . . except . . . the formulas got corupted now. Is there something that can be done about that??

J
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 takes too long to open 1
Cannot open Excel Files From Windows Explorer 3
unable to read - file too big? 1
Cannot open Excel 2002 password protected file 1
Cannot open Excel file 13
Excel cannot open the file... 1
.pst file too big to open 10
Excel Excell .xls File Growing Fast 0

Top